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