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.