Re: About table schema - Mailing list pgsql-general

From Wei Shi
Subject Re: About table schema
Date
Msg-id 20040526032924.37041.qmail@web60302.mail.yahoo.com
Whole thread Raw
In response to Re: About table schema  (Mike Mascari <mascarm@mascari.com>)
Responses Re: About table schema  (Richard Huxton <dev@archonet.com>)
List pgsql-general
This is great.  Thanks.

Wei

--- Mike Mascari <mascarm@mascari.com> 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, you'll see
> the queries it
> generates to display the meta-data associated with
> the '\' command
> you issue.
>
> You may also query the tables and views in the
> information_schema
> for what you want.
>
> Mike Mascari
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)





__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: About table schema
Next
From: Pavel Stehule
Date:
Subject: planer don't use index. bad plan for where id = x or id in (select ...)