Erik Jones <erik@myemma.com> writes:
> <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.
> 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