subject:"\[ADMIN\] CREATE TABLE LIKE and tablespaces"

Re: [ADMIN] CREATE TABLE LIKE and tablespaces

2013-03-02 Thread Christian Ullrich

* David F. Skoll wrote: I have an application that creates a daily table from a "prototype" table, so something like: CREATE TABLE data_20130226 LIKE data_prototype INCLUDING DEFAULTS INCLUDING CONSTRATINTS INCLUDING INDEXES; It would be really nice to be able to add: INCLUDING TABLESPACE

[ADMIN] CREATE TABLE LIKE and tablespaces

2013-02-27 Thread David F. Skoll

Hi, I have an application that creates a daily table from a "prototype" table, so something like: CREATE TABLE data_20130226 LIKE data_prototype INCLUDING DEFAULTS INCLUDING CONSTRATINTS INCLUDING INDEXES; It would be really nice to be able to add: INCLUDING TABLESPACE so that the daily table