Was this helpful?
Restrictions
The following restrictions apply to CREATE TABLE statements within a CREATE SCHEMA statement:
CREATE TABLE...AS SELECT cannot be used.
A WITH clause cannot be specified.
The following data types cannot be used:
integer2
integer4
float4
float8
date
The only valid WITH clause option for CREATE VIEW statements within a CREATE SCHEMA statement is WITH CHECK OPTION.
Last modified date: 11/09/2022