| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Aw: How to union all tables in a schema into one whole table? |
| Date: | 2022-10-13 17:06:07 |
| Message-ID: | trinity-00342a1e-9525-4a6f-85ac-dd8e41693675-1665680767244@3c-app-gmx-bs26 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>You can use a view, a select with union, or appropriate DDL.</div>
<div> </div>
<div>Karsten</div>
<div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Donnerstag, 13. Oktober 2022 um 19:02 Uhr<br/>
<b>Von:</b> "Shaozhong SHI" <shishaozhong(at)gmail(dot)com><br/>
<b>An:</b> "pgsql-sql" <pgsql-sql(at)lists(dot)postgresql(dot)org><br/>
<b>Betreff:</b> How to union all tables in a schema into one whole table?</div>
<div name="quoted-content">
<div>A series of table like tttt.table1, ttt.table2 has been generated in the schema ttt.
<div> </div>
<div>How best to union all these tables into a whole one?</div>
<div> </div>
<div>They have the exact same columns.</div>
<div> </div>
<div>Regards,</div>
<div> </div>
<div>David</div>
</div>
</div>
</div>
</div>
</div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Gard | 2022-10-13 17:17:00 | Re: How to union all tables in a schema into one whole table? |
| Previous Message | Shaozhong SHI | 2022-10-13 17:02:03 | How to union all tables in a schema into one whole table? |