From: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: insert retrieved data into a new table |
Date: | 2011-04-24 21:22:42 |
Message-ID: | BANLkTikL1=Np+wMrpUE5e=SQ70nYPxp7AA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sun, Apr 24, 2011 at 5:13 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
> e-letter wrote on 24.04.2011 22:52:
>
> Readers,
>>
>> Is it possible to use the result of a SELECT function to populate a
>> new table? The objective is to write the new table for use by gnuplot.
>>
>> The SELECT function features a mathematical operator such as SUM which
>> obtains a value. Is it possible to use the value from this function to
>> be entered into the new table. Please advise the relevant parts of the
>> documentation to read.
>>
>>
> CREATE TABLE new_table
> AS
> SELECT col1, col2, col3
> FROM some_table
> WHERE ...
>
> This is the syntax I always use, but I have just realized that it not
> documented in the manual...
>
>
It sure is:
http://www.postgresql.org/docs/9.0/static/sql-createtableas.html
It should be merged into the CREATE TABLE doc, IMHO.
>
> Or using SELECT INTO:
> http://www.postgresql.org/docs/current/static/sql-selectinto.html
>
> SELECTcol1, col2, col3
> INTO new_table
> FROM some_table
> WHERE ...
>
> Thomas
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
--
Gurjeet Singh
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2011-04-24 21:29:39 | Re: insert retrieved data into a new table |
Previous Message | Tom Lane | 2011-04-24 21:19:10 | Re: insert retrieved data into a new table |