Re: [GENERAL] CREATE TABLE AS... syntax?

[Len Morgan]

>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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]