i think its:
CREATE TABLE foo AS SELECT number FROM account;
tamsin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Dr. Evil
Sent: 25 April 2001 23:46
To: [EMAIL PROTECTED]
Subject: [GENERAL] CREATE TABLE AS... syntax?
I'm trying to use
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.
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]