Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1oj1ev-0003EA-7X
	for pgsql-sql@arkaria.postgresql.org; Thu, 13 Oct 2022 17:06:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1oj1et-0001Ti-On
	for pgsql-sql@arkaria.postgresql.org; Thu, 13 Oct 2022 17:06:11 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <Karsten.Hilbert@gmx.net>)
	id 1oj1et-0001TZ-FL
	for pgsql-sql@lists.postgresql.org; Thu, 13 Oct 2022 17:06:11 +0000
Received: from mout.gmx.net ([212.227.15.18])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <Karsten.Hilbert@gmx.net>)
	id 1oj1eq-0003SY-M7
	for pgsql-sql@lists.postgresql.org; Thu, 13 Oct 2022 17:06:11 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net;
	s=badeba3b8450; t=1665680767;
	bh=DR7jtzN+Z8hvLL9290zY+nqfplAiD4/zNbi3QiLd/zk=;
	h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References;
	b=QD5l67XV0nnD0diN1KXNNNXQ6SBuM5IY8/8cRk6lZN09bHtJ9iuEPbUDQUdBdhkyH
	 Rqi0Bdef1GmwJUcyc6gXdPqWzFKpzEagG126eI3LxKY4jHUATKeJsNjjyS1BXmv4aV
	 fkpUk8krvFbiJ1RQNn12rjAbFJ/imT0kVpmMQ4yQ=
X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c
Received: from [217.91.207.107] ([217.91.207.107]) by web-mail.gmx.net
 (3c-app-gmx-bs26.server.lan [172.19.170.78]) (via HTTP); Thu, 13 Oct 2022
 19:06:07 +0200
MIME-Version: 1.0
Message-ID: 
 <trinity-00342a1e-9525-4a6f-85ac-dd8e41693675-1665680767244@3c-app-gmx-bs26>
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Aw: How to union all tables in a schema into one whole table?
Content-Type: text/html; charset=UTF-8
Date: Thu, 13 Oct 2022 19:06:07 +0200
Importance: normal
Sensitivity: Normal
In-Reply-To: 
 <CA+i5JwaHBw59OWB-c6gbu==9kOGeGxDN=eZ5QN40=RxeXR1Vjg@mail.gmail.com>
References: 
 <CA+i5JwaHBw59OWB-c6gbu==9kOGeGxDN=eZ5QN40=RxeXR1Vjg@mail.gmail.com>
X-UI-Message-Type: mail
X-Priority: 3
X-Provags-ID: 
 V03:K1:i/0ncRWNbDdcUfCoi2g0R4LKmWYrX/lIjQioEmYURPw02dh+Ef2btaLICah0K8B15h0lB
 iJrjGlXmQoX3w+1tXhYm8tJFfGaPMsQCC13i6FRWN8KOjZQfvkoPlY61J+vqr1RXJGm3+xjqAuH9
 D3oWN4hXNFQge+xETYGdmqKGenJzwYouh73Njf6R+0+MRgSRZ2BptYNoG1224ohKXM+UMGNkxdzC
 zR4/6I5krTvIQzDy4xUikkuL0OBrBYL6eALr8tP5TfQApc+BOybYPAPD/SuQ9n2lpwU8ffDUUNn6
 F0=
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:fa+XrckMIKk=:C26M3DUZwTvE96isWH/Q6i
 2iB8Jfy5zSgBZk1FRjlJlsK4Fb3BOQ6wUfwbDJDUEwOk8vUZGLeCXldWmM1uJeFi3WcnHF5Bs
 0Jp7O91nO22zdRumNG84AjY5xUnnVZzyCcji+LRxOoFlqKErXGsS2IqChEcV5GLCxC2UAmXII
 +phq8IEWnMWSsh+Ta5KW+0KW5ICHzOQ9DGxg/j4MVUETiMI0x5jv/x2jbvqK/dV1k9fvWj18z
 fJSeEkgaUpfTNw1A+04B7yDhASgiNl/bs2zdg+3Vzs1uHxvdMgbkHa4OIFVlbyiq5h7VHu9YB
 pkAsucELhk8U/BKgXbgGBZ4NU/KPTtXV8HV5ZqxjUommG3hYHMVaLzjbnurEJOA/wT2+zsqSB
 7oIATip3GSDOf7k0ovOAJNQB4PK+Y6KP+h1Ic0EzCFH8XJP/aU7AYmFK+53sU9Ya5yM5QMcE8
 7CkshRUSIwqg8oc9riEXNORHP3VRL3xjySV070Acyve2jabEBCnQoW6Wg6sg9Uzdg8Ome79SR
 eBwlJMck7S3yUb3mxve1YBQf8K4LAEd5dzxk1DhkaipJ8b844nJ2TxwxSZOr/nZ9PEnzjWIog
 5U65+TtFhm2ocUSOXUGECrBMDdJyErRdl6RXoGgRPAeHKYDldAgs/vpWvh5uIz6Lc80Kox7aI
 JutL701s6eckkjJonn6bgnSfIOWnekcGVr1ekz2CStlF/lkxzYK5MyzgTSaEtFfbrNc+kIOPL
 Myq/ii3fW90x/Yh8dJrqoGrcxFWZ+MCRN6wfQ65fSUS2uoXf7rOmNR/QJbGI+kTZA/5/yCViy
 vfDFs3reY7xPvfTDXdZVFJrhnhawgfw171Owx2fr/+3RStdjcy6XeB3Ik5sGIBq9aKcQfF4/8
 hptfRKxUjmtQ11KB9LaWE0t/ivzG7pCg6hd/WJsX5phV/Rpqzel+pyY6+SWMJw8/4eq2pAjqR
 gwnKynxB4yOQpJQ8cMLtP9Kkkv/+XsnZ8kMCsgEJYA535y13MhyKQvh4vHrkY0AHeqX2fzWuS
 4W2N5rSfyXcrF9WztqRSs8EvuckAb77l/jdbJUWK/S50faQnpe0jDooYjZipFkaPfX3rv8WE8
 +yhFGwgBnuCGsfZToLMMatT0drC5/cpqxP55MsvdwqtDW6TBA/f7NTJFw2+jj0X5+jjVQlqL2
 qkUxJDFxCvwDKPMO4MZLA9ki4A/c0/CS/eYBz/sbfNveoE3idzTIYjAxi/YzRw8olnqNxlseG
 4tqGAIIA+Mvz0n06D8af1tliK6ybzpTdBVVphKWhBdiViEjLzD+Nvf344hLL4pkmFhtECuo/F
 G5Ob60ZL
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/trinity-00342a1e-9525-4a6f-85ac-dd8e41693675-1665680767244%403c-app-gmx-bs26>
Precedence: bulk

<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;shishaozhong@gmail.com&gt;<br/>
<b>An:</b>&nbsp;&quot;pgsql-sql&quot; &lt;pgsql-sql@lists.postgresql.org&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>