Meta data information on tables
Meta data information on tables
От:
jkells <jtkells@verizon.net>
Дата:
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
Re: Meta data information on tables
От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
jkells 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