select into vs. create as

From: Oskar Stolc <stolc(at)intrak(dot)sk>
To: pgsql-novice(at)postgresql(dot)org
Subject: select into vs. create as
Date: 2001-12-03 22:01:37
Message-ID: 20011203230137.B1398@intrak.tuke.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi.

Is there some difference between creating a new table with

SELECT * INTO newtable FROM oldtable;

and with

CREATE newtable as SELECT * FROM oldtable

?

Are these two commands equivalent ?

Thank you.

Oskar

PS.: Sorry for may english, I am not a native english speeker

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Burra 2001-12-03 22:29:56 binary Tuples
Previous Message Tom Lane 2001-12-03 16:09:33 Re: LISTEN & NOTIFY data