Re: CREATE TABLE AS... syntax?

>CREATE TABLE foo (test INT4) AS SELECT number FROM account;

I think you want something like:

SELECT number INTO TABLE foo FROM account ;

len morgan