Re: cannot get CREATE TABLE AS to work

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: cannot get CREATE TABLE AS to work
Date: 2001-03-09 16:49:08
Message-ID: web-22755@davinci.ethosmedia.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-03-09 16:52:30 Re: cannot get CREATE TABLE AS to work
Previous Message Josh Berkus 2001-03-09 16:45:43 Re: List Concatination