Re: SELECT INTO using Views?

On 1/9/07, Jeanna Geier <jgeier@apt-cafm.com> 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