Postgres Pro
Downloads
Home   >   mailing lists

Meta data information on tables - Mailing list pgsql-admin

From jkells
Subject Meta data information on tables
Date
Msg-id 02kSq.257143$1x3.130247@en-nntp-16.dc1.easynews.com
Whole thread Raw
Responses Re: Meta data information on tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: francis picabia
Date:
Subject: Re: Best practise for upgrade of 24GB+ database
Next
From: "Kevin Grittner"
Date:
Subject: Re: Meta data information on tables