Re: CREATE TABLE AS... syntax?

From: "Len Morgan" <len-morgan(at)crcom(dot)net>
To: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: CREATE TABLE AS... syntax?
Date: 2001-04-26 03:28:43
Message-ID: 009701c0ce00$ffc694a0$0908a8c0@H233.bstx.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>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

Browse pgsql-general by date

  From Date Subject
Next Message caldodge 2001-04-26 03:42:05 Re: CREATE TABLE AS... syntax?
Previous Message Dr. Evil 2001-04-25 22:45:38 CREATE TABLE AS... syntax?