Re: SELECT INTO using Views?

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: SELECT INTO using Views?
Date: 2007-01-09 02:05:38
Message-ID: 45A2F872.1000309@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeanna Geier 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?

SELECT INTO is used in procedural language functions to place column
values into program variables. To copy the contents of a view into a
table, look at instead CREATE TABLE AS or INSERT with SELECT.

--
Guy Rouillier

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Terenzio 2007-01-09 02:13:43 Re: COPY FROM and sequences
Previous Message Joseph Shraibman 2007-01-09 01:59:16 Re: Index vacuum improvements in 8.2