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

Reply via email to