Retrieving database schema

Поиск
Список
Период
Сортировка
Искать
От
Gary M
Тема
Retrieving database schema
Дата
Msg-id
Pine.LNX.4.44.0303222124210.25865-100000@ruby.gem
Список
Дерево обсуждения
Retrieving database schema Gary M <postgres-general@mwwm.net>
Re: Retrieving database schema Lamar Owen <lamar.owen@wgcr.org>
Re: Retrieving database schema Tom Lane <tgl@sss.pgh.pa.us>
Re: Retrieving database schema Gary M <postgres-general@mwwm.net>
Re: Retrieving database schema Lamar Owen <lamar.owen@wgcr.org>
From embedded SQL - how do I retrieve 
 1) a list of the tables in the datbase?
 2) a list of the columns in each table?


Perhaps #1 is this:

  SELECT tablename FROM pg_tables WHERE NOT schemaname = 'pg_catalog';

I'm at a loss for #2
The following doesn't seem very useful:

 SELECT * FROM pg_class WHERE relname = 'tablename';

В списке pgsql-general по дате отправления
От: Thomas T. Thai
Дата:
От: Lamar Owen
Дата:
Сообщение: Re: Retrieving database schema
FAQ