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

Re: insert retrieved data into a new table

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: insert retrieved data into a new table
Date: 2011-04-24 21:29:39
Message-ID: ip24nj$viu$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-novice
Gurjeet Singh wrote on 24.04.2011 23:22:

>     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.
>

Ah! Thanks, I was only looking at the CREATE TABLE syntax :)


In response to

pgsql-novice by date

Next:From: Marc-André LaverdièreDate: 2011-04-25 13:36:31
Subject: Re: SSL root.crt not loading
Previous:From: Gurjeet SinghDate: 2011-04-24 21:22:42
Subject: Re: insert retrieved data into a new table

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