Request a Demo
Home   >   mailing lists

Re: CREATE TABLE AS... syntax? - Mailing list pgsql-general

From Len Morgan
Subject Re: CREATE TABLE AS... syntax?
Date
Msg-id [email protected]
Whole thread Raw
In response to CREATE TABLE AS... syntax?  ("Dr. Evil" <[email protected]>)
List pgsql-general
Tree view 
>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

pgsql-general by date:

Previous
From: "Dr. Evil"
Date:
Subject: CREATE TABLE AS... syntax?
Next
From: [email protected]
Date:
Subject: Problem with pg_log file corrupted