Re: cannot get CREATE TABLE AS to work

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