Postgres Pro
Downloads
Home   >   mailing lists

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

From Len Morgan
Subject Re: CREATE TABLE AS... syntax?
Date
Msg-id 009701c0ce00$ffc694a0$0908a8c0@H233.bstx.cc
Whole thread Raw
In response to CREATE TABLE AS... syntax?  ("Dr. Evil" <drevil@sidereal.kz>)
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: YekFu.Wong@seagate.com
Date:
Subject: Problem with pg_log file corrupted