On 1/9/07, Jeanna Geier <jgeier@xxxxxxxxxxxx> 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