CREATE TABLE AS... syntax?
I'm trying to use CREATE TABLE AS under 7.03. There are no
examples in the guide, so I tried a few things:
CREATE TABLE foo (test INT4) AS SELECT number FROM account;
and
CREATE TABLE foo (test INT4) AS number FROM account;
and both of them give ERROR: parser: parse error at or near "as".
Any tips on how to use this?
Thanks
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
Import Notes
Resolved by subject fallback
"Dr. Evil" wrote:
I'm trying to use CREATE TABLE AS under 7.03. There are no
examples in the guide, so I tried a few things:CREATE TABLE foo (test INT4) AS SELECT number FROM account;
and
CREATE TABLE foo (test INT4) AS number FROM account;
and both of them give ERROR: parser: parse error at or near "as".
Any tips on how to use this?
I think you want:
CREATE TABLE foo AS SELECT number AS test FROM account;
Calvin
--
Calvin Dodge
Certified Linux Bigot (tm)
http://www.caldodge.fpcc.net
i think its:
CREATE TABLE foo AS SELECT number FROM account;
tamsin
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Dr. Evil
Sent: 25 April 2001 23:46
To: pgsql-general@postgresql.org
Subject: [GENERAL] CREATE TABLE AS... syntax?I'm trying to use CREATE TABLE AS under 7.03. There are no
examples in the guide, so I tried a few things:CREATE TABLE foo (test INT4) AS SELECT number FROM account;
and
CREATE TABLE foo (test INT4) AS number FROM account;
and both of them give ERROR: parser: parse error at or near "as".
Any tips on how to use this?Thanks
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org