Re: [GENERAL] create table as vs. create table like

On Fri, 12 Dec 2008 13:25:07 +0100 "A. Kretschmer" wrote: > In response to Ivan Sergio Borgonovo : > > I just noticed something I found "unexpected". > > > > CREATE TABLE LIKE let you specify DEFAULT and Co. > > CREATE TABLE AS doesn't. > > > > Is there a one step way to clone a table? > > wit

Re: [GENERAL] create table as vs. create table like

Andreas K. wrote: > > In response to Ivan Sergio Borgonovo : > > I just noticed something I found "unexpected". > > > > CREATE TABLE LIKE let you specify DEFAULT and Co. > > CREATE TABLE AS doesn't. > > > > Is there a one step way to clone a table? > > with or without data? > > create table ne

Re: [GENERAL] create table as vs. create table like

In response to Ivan Sergio Borgonovo : > I just noticed something I found "unexpected". > > CREATE TABLE LIKE let you specify DEFAULT and Co. > CREATE TABLE AS doesn't. > > Is there a one step way to clone a table? with or without data? create table new_table (like old_table) create table new_t

[GENERAL] create table as vs. create table like

I just noticed something I found "unexpected". CREATE TABLE LIKE let you specify DEFAULT and Co. CREATE TABLE AS doesn't. Is there a one step way to clone a table? -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To mak