RE: Describe structure.

Поиск
Список
Период
Сортировка
От Wilkinson Charlie E
Тема RE: Describe structure.
Дата
Msg-id C9077ABBC4CED311A69F0004AC3699EB02FBF543@nct0010mb03.nc.no.irs.gov
обсуждение исходный текст
Ответ на Describe structure.  ("anuj" <Anuj@in-control.de>)
Список pgsql-general

> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
>
> Wilkinson Charlie E writes:
>
> > While we're on the topic, can someone tell me where '\d *'
> went, and what to
> > use instead?
> > That particular command seems to have disappeared in PG7.
>
> Hmm, that must have been me. What did it do? Describe all
> tables at once?

Hi Peter,
Yup, that's the one.  Comes in handy for those of us who are
too lazy to describe them individually. :)

Basically what I need to do is print out a schema for all
tables in the database.  \d * used to work quite well for
me.  Is there any other option besides doing \d <table> for
each table (or creating a script to do it)?

-cw-

--
Charlie Wilkinson - TRIS Development Systems Administrator
IS:SD:CT:CC:TD
Phone: 202-283-3241
MSMail:   Charlie E Wilkinson
SMTP:  cwilkins@tris.irs.gov
Home:  cwilkins@boinklabs.com
This message constructed from 90% post-consumer electrons.

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

Предыдущее
От: Louis-David Mitterrand
Дата:
Сообщение: free auction project with Postgres
Следующее
От: Wilkinson Charlie E
Дата:
Сообщение: Access 97 Database and Postgres