RE: 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

"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

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Dr. Evil
> Sent: 25 April 2001 23:46
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
>