Save query results to new table

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Save query results to new table
Дата
Msg-id alpine.LNX.2.11.1610271652490.16551@localhost
обсуждение исходный текст
Ответы Re: Save query results to new table  (John R Pierce <pierce@hogranch.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: jaroet
Дата:
Сообщение: slow performance of array_agg after upgrade from 9.2 to 9.5
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Save query results to new table