Re: Meta data information on tables - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Meta data information on tables
Date
Msg-id 4F1989960200002500044A5F@gw.wicourts.gov
Whole thread Raw
In response to Meta data information on tables  (jkells <jtkells@verizon.net>)
List pgsql-admin
jkells <jtkells@verizon.net> wrote:

> 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

pgsql-admin by date:

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