Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL statement to copy a result set to create another table - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: SQL statement to copy a result set to create another table
Date
Msg-id 20021114153935.GA21399@wolff.to
Whole thread Raw
In response to Re: SQL statement to copy a result set to create another table  ("YC Nyon" <ycnyon@pd.jaring.my>)
List pgsql-novice
Tree view 
On Thu, Nov 14, 2002 at 11:05:50 +0800,
  YC Nyon <ycnyon@pd.jaring.my> wrote:
> I want to create a new table based on an earlier result set from a SQL
> query.

Look at the documentation for the CREATE TABLE AS command.

pgsql-novice by date:

Previous
From: "YC Nyon"
Date:
Subject: Re: SQL statement to copy a result set to create another table
Next
From: "Jules Alberts"
Date:
Subject: Re: SQL statement to copy a result set to create another table