Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

Next:From: cristiDate: 2002-11-12 06:45:37
Subject: SQL
Previous:From: Lakshmi Narayanan VDate: 2002-11-12 01:40:04
Subject: Invlalid EUC_JP character

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group