About table schema

From: Wei Shi <weishisky(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: About table schema
Date: 2004-05-25 22:36:10
Message-ID: 20040525223610.40614.qmail@web60307.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2004-05-25 22:57:59 Re: About table schema
Previous Message Tom Lane 2004-05-25 18:47:49 Re: Iterating over an varchar array?