Is there a function interface to get this information
other than from "psql" comman line interface?
Thanks.
Wei
--- Janning Vygen <vygen@gmx.de> wrote:
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/