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?