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

From Tamsin
Subject RE: CREATE TABLE AS... syntax?
Date
Msg-id NEBBKHBOBMJCHDMGKCNJCEPPCMAA.tg_mail@bryncadfan.co.uk
Whole thread Raw
In response to CREATE TABLE AS... syntax?  ("Dr. Evil" <drevil@sidereal.kz>)
List pgsql-general
i think its:
CREATE TABLE foo AS SELECT number FROM account;

tamsin

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

pgsql-general by date:

Previous
From: "Rich Handler"
Date:
Subject: Problem importing auto-increment fields in MS Access to Postgresql
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: debug logs: query: rollback