sql - CREATE SCHEMA using a name stored -
I am trying to create a new schema on my postgres database which is stored in an existing table, my query is Looks like:
Create smaima (selection name from table) but I'm getting a syntax error. What am I doing wrong? Is this a valid way to create a new schema? Which second solution exists for this problem?
It is not possible, schema syntax requires a valid schema name (i.e. valid schema name string ). The exception to your case
***************************************** ERROR: Syntax error or "State: 42601 Character: 15
Comments
Post a Comment