Re: Create Schema functionality question

From what I have just read EXECUTE requires a prepared statement but
prepared statements only work with SELECT, INSERT, UPDATE, or DELETE.

Does your suggestion take this into account? If so can you explain
further? Is your suggestions meant for "psql"?

Seamus

On Tue, 24 Feb 2004, Tom Lane wrote:

> Seamus Thomas Carroll <carrolls(at)cpsc(dot)ucalgary(dot)ca> writes:
> > Is there any possible way to create a schema without having
> > to hard code the name?
>
> Not in CREATE SCHEMA itself. But you could use a plpgsql or pltcl
> function to construct the needed command as a string, and execute
> that. In plpgsql it'd look something like
>
> DECLARE newschema text;
> ...
> SELECT INTO newschema agent_schema FROM ... WHERE ...;
> EXECUTE "CREATE SCHEMA " || quote_ident(newschema);
> ...
>
> The same goes for other utility commands (which is to say everything
> except SELECT/INSERT/UPDATE/DELETE).
>
> regards, tom lane
>