Postgres Pro
Downloads
Home   >   mailing lists

SELECT INTO using Views? - Mailing list pgsql-general

From Jeanna Geier
Subject SELECT INTO using Views?
Date
Msg-id FBEGJLLJBCOMCDBJHIMEMEKECCAA.jgeier@apt-cafm.com
Whole thread Raw
Responses Re: SELECT INTO using Views?  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: SELECT INTO using Views?  (Guy Rouillier <guyr-ml1@burntmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: George Nychis
Date:
Subject: Re: insert only unique values in to a table, ignore rest?
Next
From: Scott Ribe
Date:
Subject: Re: Database versus filesystem for storing images