Meta data information on tables

[jkells]

I am running PostgreSQL 8.4.7 (64 bit) on a Ubuntu 10.10 64 bit system.
I am trying to generate a report listing all our tables, their column
attributes (type, constraints etc.) and comments (if any) for each of
them. I'm having a hard time finding this in the catalog areas. I can
find some of this information but cant seem to tie them all together. Can
anyone help with advise or queries? Thanks

[Kevin Grittner]

Post by jkells
I am running PostgreSQL 8.4.7 (64 bit) on a Ubuntu 10.10 64 bit
system. I am trying to generate a report listing all our tables,
their column attributes (type, constraints etc.) and comments (if
any) for each of them. I'm having a hard time finding this in the
catalog areas. I can find some of this information but cant seem
to tie them all together. Can anyone help with advise or queries?
Thanks

Try running psql with the -E option, and run \d on a few tables.
psql will show all the queries used to generate its reports, which
should arm you with enough information to write what you want.

-Kevin