Re: About table schema

Am Mittwoch, 26. Mai 2004 00:36 schrieb Wei Shi:
> 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.

connect to your database with 'psql' and type

\d tablename

which gives you all information you asked for. Type \? for a list of other
commands within psql and take a look at 'man psql'

kind regards,
janning