Re: Describe Table

On Dec 17, 2007, at 10:56 AM, <danap@dandymadeproductions.com>
<danap@dandymadeproductions.com> wrote:

> I've reviewed much of the documentation and the forums,
> but unable to seem to find a easy way to obtain the same
> thing as the 'psql \d table' through sql. I know I can create
> through collecting info on table, but seems there must be an
> easier way. I desire to create a standard type SQL dump
> syntax.

If you start psql with the -E flag, it will display all sql generated
by internal commands such as those generated by \d commands.

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com