Re: [GENERAL] How can I detect if a schema exists?
On Thu, Jan 10, 2013 at 09:11:59AM +0900, Ian Lawrence Barwick wrote: > 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). I'll have to play with the users and permissions, but that sounds like it could be a feature; the code wants to know if the user can use the schema. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / fe...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How can I detect if a schema exists?
2013/1/10 > 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
[GENERAL] How can I detect if a schema exists?
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 / fe...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general