table-column relation

От:

Shankar K <shan0075@yahoo.com>

Дата:

12 сентября 2003 г. в 22:46:52

Hi,

does anybody know the internal pg_ tables that has
table/column definitions defined (similar to
user_tab_columns in oracle)

thanks,
Shankar 

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: table-column relation

От:

"A.Bhuvaneswaran" <bhuvan@symonds.net>

Дата:

13 сентября 2003 г. в 05:33:12

> does anybody know the internal pg_ tables that has table/column
> definitions defined (similar to user_tab_columns in oracle)

pg_class for tables.
pg_attribute for columns.

regards,
bhuvaneswaran