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
which gives you all information you asked for. Type \? for a list of other
commands within psql and take a look at 'man psql'
In response to
pgsql-general by date
|Next:||From: Tom Allison||Date: 2004-05-25 23:02:00|
|Previous:||From: Wei Shi||Date: 2004-05-25 22:36:10|
|Subject: About table schema|