Re: SHOW TABLES

On Thu, 15 Jul 2010 17:09:32 +0100 Thom Brown wrote:

> On 15 July 2010 17:07, Marc G. Fournier <scrappy@hub.org> wrote:
> > On Thu, 15 Jul 2010, Thom Brown wrote:
> >
> >> If it's only a psql problem, why implement it as SQL?  Is it just
> >> so we're not adding keywords specifically to psql?  In that case,
> >> it shouldn't support QUIT.
> >
> > Personally, I think this is somethign that should go into the
> > backend ... I'd like to be able to write perl scripts that talk to
> > the backend without having to remember all the various system
> > tables I need to query / join to get the same results as \d gives
> > me in psql ... same for any interface language, really ...
> >
>
> Isn't that what the information_schema catalog is for?

Is there a way to query all databases from information_schema?


Bye

--             Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project