How can I detect if a schema exists? - Mailing list pgsql-general

From felix@crowfix.com
Subject How can I detect if a schema exists?
Date
Msg-id 20130109223947.GB17453@crowfix.com
Whole thread Raw
Responses Re: How can I detect if a schema exists?  (Ian Lawrence Barwick <barwick@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master
Next
From: David Johnston
Date:
Subject: Re: How to store clickmap points?