Checking for table existence

Поиск
Список
Период
Сортировка
От Julester
Тема Checking for table existence
Дата
Msg-id prso7.50245$f7.6232115@news02.optonline.net
обсуждение исходный текст
Ответы Re: Checking for table existence  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Checking for table existence  (Roberto Mello <rmello@cc.usu.edu>)
Re: Checking for table existence  (Kovacs Baldvin <kb136@hszk.bme.hu>)
Re: Checking for table existence  ("Josh Berkus" <josh@agliodbs.com>)
Список pgsql-sql
Hi everyone.  In my old SQL Server days, I used a command such as "IF
exists(select name from sys_objects where name = 'xyztable')"  to check if a
table existed before creating it with a standard CREATE command.  I looked
in the PostgreSQL documentation, but for the life of me, I can't find an
equivalent.  I can view if the table exists by doing a select against the
meta-data tables, but what about the IF statement ?  Any help would be
greatly appreciated.  Thanks.


Julester






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

Предыдущее
От: degoble@sgtech (David. E. Goble)
Дата:
Сообщение: I could do with some guidance
Следующее
От: ke wang
Дата:
Сообщение: How to see the definition of an existing table?