You can use a view, a select with union, or appropriate DDL.

Karsten

Gesendet: Donnerstag, 13. Oktober 2022 um 19:02 Uhr
Von: "Shaozhong SHI" <shishaozhong@gmail.com>
An: "pgsql-sql" <pgsql-sql@lists.postgresql.org>
Betreff: How to union all tables in a schema into one whole table?

A series of table like tttt.table1, ttt.table2 has been generated in the schema ttt.

How best to union all these tables into a whole one?

They have the exact same columns.

Regards,

David