Re: Describe Table

Erik Jones  writes:
>  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 "; 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