SELECT INTO using Views?

From: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: SELECT INTO using Views?
Date: 2007-01-08 22:43:12
Message-ID: FBEGJLLJBCOMCDBJHIMEMEKECCAA.jgeier@apt-cafm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks much,
-Jeanna

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2007-01-08 23:19:35 Re: Database versus filesystem for storing images
Previous Message George Nychis 2007-01-08 22:42:08 Re: insert only unique values in to a table, ignore rest?