Re: data dictionary

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