Re: About table schema

Поиск
Список
Период
Сортировка
От Wei Shi
Тема Re: About table schema
Дата
Msg-id 20040526032924.37041.qmail@web60302.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: About table schema  (Mike Mascari <mascarm@mascari.com>)
Ответы Re: About table schema  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Mike Mascari
Дата:
Сообщение: Re: About table schema
Следующее
От: Pavel Stehule
Дата:
Сообщение: planer don't use index. bad plan for where id = x or id in (select ...)