Re: pg view of table columns needed for scripting

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: pg view of table columns needed for scripting
Дата
Msg-id AANLkTikF=r_MmU5aG-xxtMb+OegJJL0b69o5x5gCLQhx@mail.gmail.com
обсуждение исходный текст
Ответ на pg view of table columns needed for scripting  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Список pgsql-general
Дерево обсуждения 
On Fri, Oct 22, 2010 at 9:14 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> Is there something like a pg_xxx view that I can use to get the column names
> and data types of a table, similar to what I see with \d ?  I need to run
> this is a script, so \d isn't viable.  I did a \df and looked around, but
> nothing popped out.

psql -E -d dbname

Will give you the internal queries that are executed by things like \d etc

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Bex
Дата:
Сообщение: Re: Advice needed on application/database authentication/authorization/auditing model
Следующее
От: Chris Barnes
Дата:
Сообщение: Re: pg view of table columns needed for scripting