Adding Results of a query from different tables To A new Table In PostgreSQL

Question

I have 20 tables and I wanted to perform a same query from all of them. Subsequently, I want to add the result of the all the queries to a new table. Tables include temperature, coordinate and time_date columns. And query is about creating sub-set of each table. The resulted new table should include the result of each query. In other words it should include aforementioned 3 column which are filled by the result of query from different tables.

The aforementioned code which should be applied for all the tables. is:

select *
FROM s3
WHERE dt::timestamptz BETWEEN DATE '2007-09-14' AND DATE '2007-10-03' 
  AND extract(hour FROM dt::timestamptz) BETWEEN 8 AND 20
ORDER BY dt

As a result there should be a new table which include temperature, coordinate and time_date columns with respect to the output of the query form all the tables. Note: Sequence of filling is not important in a new table.

mys · Accepted Answer · 2012-11-27 12:24:41Z

1

you can always use union all:

create table T as
select * from ...
union all
select * from ...
union all
...

answered Nov 27, 2012 at 12:24

mys

2,50319 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding Results of a query from different tables To A new Table In PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related