Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.



Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger. 


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group