How can I detect if a schema exists?

From: felix(at)crowfix(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: How can I detect if a schema exists?
Date: 2013-01-09 22:39:47
Message-ID: 20130109223947.GB17453@crowfix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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 ...

--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix(at)crowfix(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-01-10 00:11:59 Re: How can I detect if a schema exists?
Previous Message Tom Lane 2013-01-09 21:51:49 Re: [Solved] Corrupt indexes on slave when using pg_bulkload on master