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