Re: SQL statement to copy a result set to create another table

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: YC Nyon <ycnyon(at)pd(dot)jaring(dot)my>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL statement to copy a result set to create another table
Date: 2002-11-14 15:39:35
Message-ID: 20021114153935.GA21399@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Nov 14, 2002 at 11:05:50 +0800,
YC Nyon <ycnyon(at)pd(dot)jaring(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Rodrigues 2002-11-15 04:30:33 using functions to generate custom error messages
Previous Message Jules Alberts 2002-11-14 15:27:21 Re: SQL statement to copy a result set to create another table