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
Is there a function interface to get this information
other than from "psql" comman line interface?
Thanks.
Wei
--- Janning Vygen <[EMAIL PROTECTED]> wrote:
> Am Mittwoch, 26. Mai 2004 00:36 schrieb Wei Shi:
> > Hi, does anyone know how to get the schema
> infor
This is great. Thanks.
Wei
--- Mike Mascari <[EMAIL PROTECTED]> wrote:
> Wei Shi wrote:
> > Is there a function interface to get this
> information
> > other than from "psql" comman line interface?
>
> If you start psql with the '-E' switch, y
