Wei Shi wrote:
> 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.
Use the information schema views.
In response to
pgsql-general by date
|Next:||From: Frank Finner||Date: 2004-05-26 17:46:32|
|Subject: Re: performance very slow|
|Previous:||From: pgsql||Date: 2004-05-26 17:18:24|
|Subject: Re: Ingres to be released as open source|