Postgres Pro
Downloads
Home   >   mailing lists

About table schema - Mailing list pgsql-general

From Wei Shi
Subject About table schema
Date
Msg-id 20040525223610.40614.qmail@web60307.mail.yahoo.com
Whole thread Raw
Responses Re: About table schema  (Janning Vygen <vygen@gmx.de>)
Re: About table schema  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
Hi, does anyone know how to get the schema information
of a table.  More specifically, I would like to know

1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is referring to.

Thanks.

Wei





__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Iterating over an varchar array?
Next
From: Janning Vygen
Date:
Subject: Re: About table schema