Quick Links

create table as vs. create table like

From:	Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To:	pgsql-general(at)postgresql(dot)org
Subject:	create table as vs. create table like
Date:	2008-12-12 12:02:29
Message-ID:	20081212130229.33909514@dawn.webthatworks.it
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

Re: create table as vs. create table like at 2008-12-12 12:25:07 from A. Kretschmer

	From	Date	Subject
Next Message	Adam Witney	2008-12-12 12:16:45	Implementing programatic access to a database using dblink?
Previous Message	Thomas Kellerer	2008-12-12 09:34:51	Logg errors during UPDATE