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: 20040525223610.40614.qmail@web60307.mail.yahoo.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group