Re: How can I detect if a schema exists?

Поиск
Список
Период
Сортировка
От Ian Lawrence Barwick
Тема Re: How can I detect if a schema exists?
Дата
Msg-id CAB8KJ=iornCwNQGTPS=YRdaVOnvJ545Kqi=Oz5OUR-AmEX3+zw@mail.gmail.com
обсуждение исходный текст
Ответ на How can I detect if a schema exists?  (felix@crowfix.com)
Ответы Re: How can I detect if a schema exists?  (felix@crowfix.com)
Список pgsql-general
2013/1/10 <felix@crowfix.com>
I was reviving an old test program which hasn't been used since 9.1 and found that "SET search_path = xyzzy" no longer fails if the schema "xyzzy" doesn't exist.

Is there an approved or recommended way to tell if a schema exists?  I can think of lots of ways, but none as easy as the 9.1 search_path.  I suppose I shouldn't rely on undocumented features ...

How about:

  SELECT TRUE FROM information_schema.schemata WHERE schema_name = 'xyzzy'

? (Though I notice this table only seems to show the schemas owned by the user if the user is not a superuser).

Ian Lawrence Barwick 

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

Предыдущее
От: Fredrik.HuitfeldtMadsen@schneider-electric.com
Дата:
Сообщение: Database connections seemingly hanging
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Error: absolute path not allowed