How can I detect if a schema exists?

Поиск
Список
Период
Сортировка
От felix@crowfix.com
Тема How can I detect if a schema exists?
Дата
Msg-id 20130109223947.GB17453@crowfix.com
обсуждение исходный текст
Ответы Re: How can I detect if a schema exists?  (Ian Lawrence Barwick <barwick@gmail.com>)
Список pgsql-general
I was reviving an old test program which hasn't been used since 9.1 and found that "SET search_path = xyzzy" no longer
failsif 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
the9.1 search_path.  I suppose I shouldn't rely on undocumented features ... 

--
            ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
     Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Следующее
От: David Johnston
Дата:
Сообщение: Re: How to store clickmap points?