Re: [GENERAL] Using SELECT to get table info.

Hey Paul,

Try doing a \dS from your postgres command prompt.

It lists all the system's tables and - in there somewhere ?? - is all of
the stuff you'll need. I actually spent some time trying to figure
this stuff out once and I found out that postgres keeps a lot of data
that I don't understand. If you want I can send you along a little
memo I wrote to some of the programmers here, at Palaver.

But, some more experienced psql user will probably be able to steer you
more directly at what you're looking for.

Lemme know,

Bob

On Tue, 26 Jan 1999, Paul Ramsey wrote:

> In Oracle, it is possible to get information about a table space by
> using a SQL select statement thusly: SELECT * from ALL_TABLES
> Is there an equivalent SQL trick in pgsql?
> Thanks,
> Paul
>
>