Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot get CREATE TABLE AS to work - Mailing list pgsql-sql

From Josh Berkus
Subject Re: cannot get CREATE TABLE AS to work
Date
Msg-id web-22755@davinci.ethosmedia.com
Whole thread Raw
In response to cannot get CREATE TABLE AS to work  ("Creager, Robert S" <CreagRS@LOUISVILLE.STORTEK.COM>)
List pgsql-sql
Tree view 
Robert,
I can't help you with your performance problem, but I can help you with
CREATE TABLE AS.  You've mistaken the syntax; CREATE TABLE AS does not
use column definitions other than the query.  Thus, the correct syntax
should be:


> create table observationsII
> AS select o.ra, o.decl, o.mag, o.smag, o.file_id from
> observations o;


-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: List Concatination
Next
From: Josh Berkus
Date:
Subject: Re: cannot get CREATE TABLE AS to work