9. Extended Statements : CREATE SCHEMA : Restrictions
 
Share this page                  
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.