Re: data dictionary?

On Wed, 18 Oct 2000, Beth Gatewood wrote:

> Hi-
> 
> New to PostGreSQL...previously used Oracle.
> 
> Could someone please tell me where the Data Dictionary is located?
> Specifically, I want to get a list of tables.  I know about the \dt
> command but I would like to see where this is actually stored (so that I
> 
> can execute SQL against it).

Hi Beth,

SELECT * FROM pg_class;

is a good place to start when querying the system catalogue.
BTW, default tables (sys catalogue) are stored in:

/usr/local/pgsql/data/base/template1

Cheers,
Tom

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
IS Coordinator / DBA                 Phone: 718-354-5528 
                                     Fax:   718-354-5056  
--------------------------------------------------------------------
Powered by:  PostgreSQL     s l a c k w a r e          FreeBSD:
               RDBMS       |---------- linux      The Power To Serve
--------------------------------------------------------------------