Skip site navigation (1) Skip section navigation (2)

Re: insert retrieved data into a new table

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Thomas KellererDate: 2011-04-24 21:29:39
Subject: Re: insert retrieved data into a new table
Previous:From: Tom LaneDate: 2011-04-24 21:19:10
Subject: Re: insert retrieved data into a new table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group