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 :)