| From: | Wei Shi <weishisky(at)yahoo(dot)com> |
|---|---|
| To: | Mike Mascari <mascarm(at)mascari(dot)com> |
| Cc: | Janning Vygen <vygen(at)gmx(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: About table schema |
| Date: | 2004-05-26 03:29:24 |
| Message-ID: | 20040526032924.37041.qmail@web60302.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This is great. Thanks.
Wei
--- Mike Mascari <mascarm(at)mascari(dot)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(at)postgresql(dot)org)
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2004-05-26 06:20:43 | planer don't use index. bad plan for where id = x or id in (select ...) |
| Previous Message | Mike Mascari | 2004-05-26 02:31:20 | Re: About table schema |