Re: Describe Table

Erik Jones <erik(at)myemma(dot)com> writes:
> <danap(at)dandymadeproductions(dot)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.

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

Another alternative is to run "pg_dump -s -t <table>"; that will get you
a lot closer to SQL-ready output, and you won't need to worry as much
about updating your code for future system catalog changes.

regards, tom lane