Re: newbie needs help with postgres internal tables - Mailing list pgsql-general

From Tom Lane
Subject Re: newbie needs help with postgres internal tables
Date
Msg-id 9655.1006542897@sss.pgh.pa.us
Whole thread Raw
In response to Re: newbie needs help with postgres internal tables  (William WAISSE <wwaisse@esprit-equipe.fr>)
Responses Re: newbie needs help with postgres internal tables
List pgsql-general
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

pgsql-general by date:

Previous
From: Luis Amigo
Date:
Subject: explain analyze
Next
From: Luis Amigo
Date:
Subject: enable_nestloop