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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin