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

From: "YC Nyon" <ycnyon(at)pd(dot)jaring(dot)my>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SQL statement to copy a result set to create another table.
Date: 2002-11-12 02:14:07
Message-ID: 000301c28a05$709f41b0$5340ba66@gis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I want to create a new table based on an earlier result set from a SQL
query.
For example;
Query 1:
Select * from test where id >20

This will give me a result that 10 records found.
I would like to create a new table and insert these 10 records.
Also, I looking into views. would that be a better choice. The application
let users store their data via PHP.

Thanks
Nyon

Browse pgsql-novice by date

  From Date Subject
Next Message cristi 2002-11-12 06:45:37 SQL
Previous Message Lakshmi Narayanan V 2002-11-12 01:40:04 Invlalid EUC_JP character