Aw: How to union all tables in a schema into one whole table?

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Karsten Hilbert <[email protected]>
To: Shaozhong SHI <[email protected]>
Cc: pgsql-sql <[email protected]>
Subject: Aw: How to union all tables in a schema into one whole table?
Date: Thu, 13 Oct 2022 19:06:07 +0200
Message-ID: <trinity-00342a1e-9525-4a6f-85ac-dd8e41693675-1665680767244@3c-app-gmx-bs26> (raw)
In-Reply-To: <CA+i5JwaHBw59OWB-c6gbu==9kOGeGxDN=eZ5QN40=RxeXR1Vjg@mail.gmail.com>
References: <CA+i5JwaHBw59OWB-c6gbu==9kOGeGxDN=eZ5QN40=RxeXR1Vjg@mail.gmail.com>

<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>&nbsp;</div>

<div>Karsten</div>

<div>&nbsp;
<div>&nbsp;
<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>&nbsp;Donnerstag, 13. Oktober 2022 um 19:02 Uhr<br/>
<b>Von:</b>&nbsp;&quot;Shaozhong SHI&quot; &lt;[email protected]&gt;<br/>
<b>An:</b>&nbsp;&quot;pgsql-sql&quot; &lt;[email protected]&gt;<br/>
<b>Betreff:</b>&nbsp;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>&nbsp;</div>

<div>How best to union all these tables into a whole one?</div>

<div>&nbsp;</div>

<div>They have the exact same columns.</div>

<div>&nbsp;</div>

<div>Regards,</div>

<div>&nbsp;</div>

<div>David</div>
</div>
</div>
</div>
</div>
</div></div></body></html>

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Aw: How to union all tables in a schema into one whole table?
  In-Reply-To: <trinity-00342a1e-9525-4a6f-85ac-dd8e41693675-1665680767244@3c-app-gmx-bs26>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox