I must be daft, but I can't figure out what is wrong with this
Started by Dann Corbitalmost 21 years ago2 messagesgeneral
I am toying around with a SQL92 INFORMATION_SCHEMA model. I have
created the SQL to try to explore the idea, but I can't get off the
ground.
What is my utter and obvious idiocy?
E.g.:
schema_test=> CREATE SCHEMA INFORMATION_SCHEMA AUTHORIZATION
INFORMATION_SCHEMA ;
ERROR: parser: parse error at or near "authorization"
schema_test=>
Re: I must be daft, but I can't figure out what is wrong with this
"Dann Corbit" <DCorbit@connx.com> writes:
schema_test=> CREATE SCHEMA INFORMATION_SCHEMA AUTHORIZATION
INFORMATION_SCHEMA ;
ERROR: parser: parse error at or near "authorization"
schema_test=>
Judging by the spelling of the error message, you're trying to do this
in a pre-7.3 PG. We didn't have schemas back then.
regards, tom lane