| Lists: | pgsql-general |
|---|
| From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Using SELECT to get table info. |
| Date: | 1999-01-26 18:32:41 |
| Message-ID: | 36AE0A49.44F45DF5@refractions.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Bob Dusek <bobd(at)palaver(dot)net> |
|---|---|
| To: | Paul Ramsey <pramsey(at)refractions(dot)net> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Using SELECT to get table info. |
| Date: | 1999-01-26 18:56:13 |
| Message-ID: | Pine.LNX.3.96.990126135400.13491A-100000@farout.palaver.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
>
>
| From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
|---|---|
| To: | Bob Dusek <bobd(at)palaver(dot)net>, Paul Ramsey <pramsey(at)refractions(dot)net> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Using SELECT to get table info. |
| Date: | 1999-01-27 10:05:02 |
| Message-ID: | l03110701b2d4950e2aad@[147.233.159.109] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
At 20:56 +0200 on 26/01/1999, Bob Dusek wrote:
>
> But, some more experienced psql user will probably be able to steer you
> more directly at what you're looking for.
Basically, do a "man catalogs". This man page gives all the system tables
and their fields. The general table in which to search of tables is
pg_class.
Herouth