list all columns in db

Поиск
Список
Период
Сортировка
От Jonathan Vanasco
Тема list all columns in db
Дата
Msg-id 43A02BFC-953B-49BC-AEF2-A1956CE07287@2xlp.com
обсуждение исходный текст
Ответы Re: list all columns in db  (Rodrigo De León <rdeleonp@gmail.com>)
Re: list all columns in db  (Jon Sime <jsime@mediamatters.org>)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Suppress checking of chmod 700 on data-dir?
Следующее
От: "George Pavlov"
Дата:
Сообщение: Re: index vs. seq scan choice?