select into vs. create as - Mailing list pgsql-novice

From Oskar Stolc
Subject select into vs. create as
Date
Msg-id 20011203230137.B1398@intrak.tuke.sk
Whole thread Raw
Responses Re: select into vs. create as
List 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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: LISTEN & NOTIFY data
Next
From: Tom Lane
Date:
Subject: Re: select into vs. create as