Re: How can I check if table exists in DB?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: How can I check if table exists in DB?
Дата
Msg-id 20031118083201.H41108@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: How can I check if table exists in DB?  (Sergey Belikov <belikov@bnl.gov>)
Ответы pg_dumpall pg_restore  ("Rob Sell" <lists@facnd.com>)
Список pgsql-novice
On Tue, 18 Nov 2003, Sergey Belikov wrote:

> Hi Bruno!
> Thank you very much for your help!!! It works very nicely!!!
> Yet as I understand pg_tables is a system table. In some book I got
> advice to not rely on a schema of system tables.
>  Is there any warranty that the field names will not be changed in
> pg_tables table for at least 5 years?

Not really, but in 7.4, you'll have access to the standard
information_schema.tables which should basically stay the same barring
changes in its definition in the SQL spec.

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

Предыдущее
От: Sergey Belikov
Дата:
Сообщение: Re: How can I check if table exists in DB?
Следующее
От: Andrei Ivanov
Дата:
Сообщение: ERROR: nodeRead: did not find '}'