Gurjeet Singh wrote on 24.04.2011 23:22:
> CREATE TABLE new_table
> 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:
> 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ère||Date: 2011-04-25 13:36:31|
|Subject: Re: SSL root.crt not loading|
|Previous:||From: Gurjeet Singh||Date: 2011-04-24 21:22:42|
|Subject: Re: insert retrieved data into a new table|