Re: newbie question... how do I get table structure?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: newbie question... how do I get table structure?
Дата
Msg-id 200402061542.15214.dev@archonet.com
обсуждение исходный текст
Ответ на Re: newbie question... how do I get table structure?  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
Список pgsql-general
On Friday 06 February 2004 15:00, Franco Bruno Borghesi wrote:
>
> Does anyone know if the ansi sql standard defines any way to do this?
> I've seen the DESCRIBE TABLE/INDEX/... or SHOW TABLE/INDEX/... commands
> in other databases, but I don't really know if they are extensions or
> not.

There's the new information schema, which displays standard info in 7.4 -
support elsewhere is variable I believe.

--
  Richard Huxton
  Archonet Ltd

В списке pgsql-general по дате отправления:

Предыдущее
От: "Andy Kriger"
Дата:
Сообщение: how can I select into an array?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Run 2 versions of Postgresql on one machine?