list all columns in db - Mailing list pgsql-general

From Jonathan Vanasco
Subject list all columns in db
Date
Msg-id 43A02BFC-953B-49BC-AEF2-A1956CE07287@2xlp.com
Whole thread Raw
Responses Re: list all columns in db  (Rodrigo De León <rdeleonp@gmail.com>)
Re: list all columns in db  (Jon Sime <jsime@mediamatters.org>)
List 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
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - -



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Suppress checking of chmod 700 on data-dir?
Next
From: "George Pavlov"
Date:
Subject: Re: index vs. seq scan choice?