Re: data dictionary

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Matthew Taylor <bmatthewtaylor(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: data dictionary
Date: 2001-01-19 11:38:26
Message-ID: Pine.LNX.4.30.0101190636070.11365-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Fri, 19 Jan 2001, Matthew Taylor wrote:

> Umm I must have missed it in the manual, (read it 3-4 times tho) but what is
> the equivalent data dictionary structure in Postgres to the following in
> Oracle.
>
> Select table_name from user_tables;
>
> (gives a list of the table names in the database(table space) used at the
> time)
>
> etc.... various special tables defining the data dictionary....

Take a look at pg_class and pg_tables (which is a view based on pg_class),
which are available for each schema:

select * from pg_tables where tableowner=CURRENT_USER;

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
A woman without a man is like a fish without a bicycle.
-- Gloria Steinem

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-01-19 15:19:19 Re: GRANT odd behaviour - Bug or feature?
Previous Message J.H.M. Dassen (Ray) 2001-01-19 11:25:20 Re: data dictionary

Browse pgsql-general by date

  From Date Subject
Next Message Cedar Cox 2001-01-19 11:41:20 Re: [INTERFACES] pl/pgSQL & transaction
Previous Message J.H.M. Dassen (Ray) 2001-01-19 11:25:20 Re: data dictionary