Re: newbie needs help with postgres internal tables

William WAISSE <wwaisse@esprit-equipe.fr> writes:
>  It's necessary cause I want to display in a treeview ( GtkCtree ) all the
> the tables in a particular database, and for each table, all the fields in
> this table ).

You can only see tables of the database you are connected to.  To do the
above, you'd need to open a connection to each database in turn
(assuming that the installation is configured to let you get into all of
them...)

pg_database is visible from all databases, and so are pg_shadow and
pg_group, but AFAIR everything else is database-local.

            regards, tom lane