On 10/27/2016 4:57 PM, Rich Shepard wrote:
It's been several years since I worked with postgres so I tried
searching
the web for the correct syntax to save query results to a new table, but
without results.
I'm running postgresql-9.5.4 here. The query extracts 28162 rows from a
table of 122365 rows. I thought 'save table as' would do the job but have
not found the correct syntax to do this.
My query is:
select * from monitor_sites where param = 'Cd' or param = 'Co' or
param = 'As' or param = 'Hg' or param = 'Zn' or param = 'Pb' or param
= 'Cr' or
param = 'Cu';
If you point me to the appropriate page in the 9.5.x manual I'll
figure it
CREATE TABLE newtable AS SELECT ...
https://www.postgresql.org/docs/9.5/static/sql-createtableas.html
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
