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

From YC Nyon
Subject Re: SQL statement to copy a result set to create another table.
Date
Msg-id 000301c28a05$709f41b0$5340ba66@gis
Whole thread Raw
List 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


pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Re: Cancelling long running query?
Next
From: "Josh Berkus"
Date:
Subject: Re: return column id from insert