Hi,
I am trying to create a schema where the schema name has been defined in
another table. My sql looks like:
create schema (select agent_schema from agents.agents where agent_id =
(select(last_value) from agents.agents_seq));
The select statement works correctly on its own but when added to
"create schema" I get the following error:
ERROR: syntax error at or near "(" at character 15
Is there any possible way to create a schema without having
to hard code the name?
Seamus
