Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: select into vs. create as
Date
Msg-id 19637.1007418730@sss.pgh.pa.us
Whole thread Raw
In response to select into vs. create as  (Oskar Stolc <stolc@intrak.sk>)
List pgsql-novice
Tree view 
Oskar Stolc <stolc@intrak.sk> writes:
> Are these two commands equivalent ?

Yes.

I recommend CREATE AS, though.  plpgsql thinks that SELECT INTO
means something quite different, so you'll inevitably get confused
later on if you use SELECT INTO :-(

            regards, tom lane

pgsql-novice by date:

Previous
From: Oskar Stolc
Date:
Subject: select into vs. create as
Next
From: Burra
Date:
Subject: binary Tuples