RE: Describe structure.

> -----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.