Re: SHOW TABLES - Mailing list pgsql-hackers

From Andreas 'ads' Scherbaum
Subject Re: SHOW TABLES
Date
Msg-id 20100715192136.26037c97@platin.wars-nicht.de
Whole thread Raw
In response to Re: SHOW TABLES  (Thom Brown <thombrown@gmail.com>)
Responses Re: SHOW TABLES
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: SHOW TABLES
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: SHOW TABLES