On 1/9/07, Jeanna Geier <[EMAIL PROTECTED]> wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it....
So, would I be able to copy the data from the View to the Table using the
SELECT INTO command?
Administrator=# create temp view v as select 'postgresql r0x0r'::text;
CREATE VIEW
Administrator=# create temp table t as select * from v;
SELECT
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
