From: | "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron-office(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: data dictionary |
Date: | 2001-01-19 11:25:20 |
Message-ID: | 20010119122520.A13425@cistron-office.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Fri, Jan 19, 2001 at 21:29:41 +1100, 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;
> etc.... various special tables defining the data dictionary....
PostgreSQL stores its meta-data in tables named pg_something, e.g. for
7.0.3:
pg_aggregate pg_description pg_listener pg_statistic
pg_am pg_group pg_opclass pg_tables
pg_amop pg_index pg_operator pg_trigger
pg_amproc pg_indexes pg_proc pg_type
pg_attrdef pg_inheritproc pg_relcheck pg_user
pg_attribute pg_inherits pg_rewrite pg_views
pg_class pg_ipl pg_rules
pg_database pg_language pg_shadow
(obtained by doing "select * from pg_" <TAB> in "psql")
HTH,
Ray
--
Would you rather be root or reboot?
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 2001-01-19 11:38:26 | Re: data dictionary |
Previous Message | Matthew Taylor | 2001-01-19 10:29:41 | data dictionary |
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 2001-01-19 11:38:26 | Re: data dictionary |
Previous Message | Matthew Taylor | 2001-01-19 10:29:41 | data dictionary |