Save query results to new table

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Save query results to new table
Date: 2016-10-27 23:57:54
Message-ID: alpine.LNX.2.11.1610271652490.16551@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
out.

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-10-28 00:00:59 Re: Save query results to new table
Previous Message Bill Moran 2016-10-27 19:53:46 Re: The consequenses of interrupted vacuum