Re: CREATE TABLE AS and tablespaces

Markus Schaber wrote:
> Hello,
> 
> Recently, I wanted to create a table from a complex query in a specific
> tablespace, but CREATE TABLE name AS SELECT ... does not accept a
> tablespace argument.
> 
> I worked around it by CREATE TABLE name AS SELECT ... LIMIT 0, then
> moving the generated table to the other tablespace using ALTER TABLE,
> and then using INSERT INTO ... SELECT to generate the data into the table.
> 
> But nevertheless, I'd like to ask here whether there are specific
> reasons for omitting the tablespace argument from the CREATE TABLE AS
> statement. If not, I'd like to request this minor feature :-)
> 
> Maybe it is even possible to further unify CREATE TABLE and CREATE TABLE AS.

This feature will be in 8.2:revision 2.530date: 2006/02/19 00:04:27;  author: neilc;  state: Exp;  lines: +16 -20Add
TABLESPACEand ON COMMIT clauses to CREATE TABLE AS. ON COMMIT isrequired by the SQL standard, and TABLESPACE is useful
functionality.Patchfrom Kris Jurka, minor editorialization by Neil Conway.
 


--  Bruce Momjian   http://candle.pha.pa.us SRA OSS, Inc.   http://www.sraoss.com
 + If your life is a hard drive, Christ can be your backup. +