Re: newbie needs help with postgres internal tables

William WAISSE wrote:

>
>Le Friday 23 November 2001 12:23, Tom Lane a écrit :
>
>>See the "system catalogs" chapter of the developer's guide. It's a bit
>>terse but I believe the information you mention above is all stated at,
>>eg,
>>http://candle.pha.pa.us/main/writings/pgsql/sgml/catalog-pg-attribute.html
>>
> hum, now I looked at those catalogs, I'm nearly sure there is no id in
>pg_database that would allow me to select all the tables ( class ) that
>belong to a particular database.
>
> Whereas it's possible to find all the fields in a table ).
>
> This seems to me impossible !
>

Hi,

If you set the ECHO_HIDDEN variable in psql, or start psql with the -E
option, you'll see the queries used by commands like \dt and others. You
could emulate then in your application.

Regards,

Antonio Sergio