Home > mailing lists

create table as vs. create table like - Mailing list pgsql-general

From	Ivan Sergio Borgonovo
Subject	create table as vs. create table like
Date	December 12, 2008 11:02:48
Msg-id	20081212130229.33909514@dawn.webthatworks.it Whole thread Raw
Responses	Re: create table as vs. create table like ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Thomas Kellerer
Date: 12 December 2008, 08:35:11
Subject: Logg errors during UPDATE

From: Adam Witney
Date: 12 December 2008, 11:17:01
Subject: Implementing programatic access to a database using dblink?

create table as vs. create table like - Mailing list pgsql-general

Previous

Next