I'm trying to use CREATE TABLE AS under 7.03. There are no
examples in the guide, so I tried a few things:
CREATE TABLE foo (test INT4) AS SELECT number FROM account;
and
CREATE TABLE foo (test INT4) AS number FROM account;
and both of them give ERROR: parser: parse error at or near "as".
Any tips on how to use this?
Thanks