Thread: Save query results to new table

Save query results to new table

From
Rich Shepard
Date:
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


Re: Save query results to new table

From
John R Pierce
Date:
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



Re: Save query results to new table [RESOLVED]

From
Rich Shepard
Date:
On Thu, 27 Oct 2016, John R Pierce wrote:

> CREATE TABLE newtable AS SELECT ...
> https://www.postgresql.org/docs/9.5/static/sql-createtableas.html

   Thank you, John.

Much appreciated,

Rich