| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | list all columns in db |
| Date: | 2007-06-07 21:34:29 |
| Message-ID: | 43A02BFC-953B-49BC-AEF2-A1956CE07287@2xlp.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Does anyone have a trick to list all columns in a db ?
I need to audit a few dbs to make sure column & table names are
adhering to our standard semantic syntax.
i figure there has to be an old pg-admin trick out there to display
a db like
%(tname)s . %(cname)
or some similar format
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| CEO/Founder SyndiClick Networks
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Osvaldo Kussama | 2007-06-07 21:41:21 | Re: subtract a day from the NOW function |
| Previous Message | Steve Crawford | 2007-06-07 21:07:33 | Re: subtract a day from the NOW function |