Re: query for schema existence and create schema in jdbc?

On Fri, Jan 21, 2011 at 6:14 AM, Hiller, Dean (Contractor) <
dean(dot)hiller(at)broadridge(dot)com> wrote:

> I need a way(and don’t care if it is not portable) to
>
>
>
> 1. Query to see if a schema exists or not
>
> 2. Create the schema if it doesn’t exist
>
> 3. Drop and recreate the schema if it does exist
>
>
>
> ALL through JDBC. Is this possible?
>

run this query, which returns a boolean:

select exists (select * from pg_catalog.pg_namespace where nspname =
'new_schema');

then either execute 'create schema new_schema;' or 'drop schema new_schema
cascade; create schema new_schema;'