Search Postgresql Archives

Re: postgres slower on nested queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Mar 07, 2007 at 12:12:52PM +0100, Alexander Elgert wrote:
> >Nope - \d is psql only. That's because what it does changes with the 
> >system catalogues. If you want a stable representation, use the 
> >information_schema. If you want all the PostgreSQL-specific details 
> >you'll have to cope with changes to the system catalogues. However, I 
> >seem to remember some utility views that pgadmin uses that might be of 
> >use.
> It would be nice to have the \d-query stored somewhere in the database.

Not really useful anyway. For the kind of trivial stuff you're doing
the queries will work for many many versions. Your real problem is that
you're using the information_schema which has to do all sorts of extra
work for standards compliance. If you don't need that you're going to
be much better off just using the system catalogs.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux