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 ) id 1oj1b8-0002tm-Nf for pgsql-sql@arkaria.postgresql.org; Thu, 13 Oct 2022 17:02:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oj1b7-0006Vw-4x for pgsql-sql@arkaria.postgresql.org; Thu, 13 Oct 2022 17:02:17 +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 ) id 1oj1b6-0006UR-Sl for pgsql-sql@lists.postgresql.org; Thu, 13 Oct 2022 17:02:16 +0000 Received: from mail-ed1-x535.google.com ([2a00:1450:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oj1b4-0003Q9-Sy for pgsql-sql@lists.postgresql.org; Thu, 13 Oct 2022 17:02:16 +0000 Received: by mail-ed1-x535.google.com with SMTP id s2so3533218edd.2 for ; Thu, 13 Oct 2022 10:02:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=+o/OR1zkCr3Tqe5dCkww/H9zVA9nrBImALQNz3VcK9w=; b=FI9DYoGhRK4ivE1lbHOb9a5dK6cWrR+Fc87rYghaFJLviU9BsILQvLp+GKfpGZJcIF FbRQm/YqQnM44Oik9HVrnzu2x1wFn4J8l3HodIKp5cDzkpx32ISAtC9cq8LM3+smc9jo 59nPyM+5g7MJY/CC95vmvw5lSb8dNHnCN23O8FvK5akNWh3Uk+stUP7y/iMurQvfeuhC EpAGbv0h13UG02Z2yQxGnRmJkmStufXKtVy/znk6jf4TlaIuptelhu3ZmabIv4EEV+cb SpHa09LquF6bHrnGLx3xdiymrOm28zwWj2JZDoy2pFCxtm79dxK/7jFwwOAXJvLJd+3K vTIQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=+o/OR1zkCr3Tqe5dCkww/H9zVA9nrBImALQNz3VcK9w=; b=VlYOIqjh5fER1CF2CiZFVe6v4+2ZqXFWjBHeb/oBYH1EXEG2QapVW8bpv95KU63vAg mUYuXbK0k3UG7FEvDtcX/IhcBUSje4aV7+xHjSGFgdCV7eI4SfA0n/ztNUXzz6fQOpNS 9dVHwUz8mq6x3M/1Ah7rdWBK/PkcFQVLJwAgTVfPvfH5K8eUOAXUzenRXUgi8Vh8ZUnc OEoX4dh9B2kd16Vtj4kSj0WgM2eF//J8D5LJr9zBuhGdZIfwcKKD1aAsThsIpvTEjS1W dpmThigaci+JkjCHp4w7Rk45EhXCoLqdupkBWNxdgrASMgAqScfTv4NPfK9duZygsszW YJ/A== X-Gm-Message-State: ACrzQf1XaKAsjfJ6fj8W2bX4bE5Y8X7Yq5PIfVE516Z2giIH0bRo8N0O UCnjCcHppMXgSr8L1HzpMSZDZCn0e5N9jluDj88hroKS X-Google-Smtp-Source: AMsMyM4zcgV8WxgC0gPO4+jluxtuma5S8L86X5g+6DKO0sn7bcSBhwqsBz5ol0arV50gjK2fV+wYSK/Gve//kJ6+IQ4= X-Received: by 2002:a05:6402:3887:b0:458:289e:c9cc with SMTP id fd7-20020a056402388700b00458289ec9ccmr623781edb.101.1665680534075; Thu, 13 Oct 2022 10:02:14 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Thu, 13 Oct 2022 18:02:03 +0100 Message-ID: Subject: How to union all tables in a schema into one whole table? To: pgsql-sql Content-Type: multipart/alternative; boundary="0000000000008aff4a05eaed7866" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008aff4a05eaed7866 Content-Type: text/plain; charset="UTF-8" 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 --0000000000008aff4a05eaed7866 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
A series of table like tttt.table1, ttt.table2 has been ge= nerated in the schema ttt.

How best to union all these t= ables into a whole one?

They have the exact same c= olumns.

Regards,

David
--0000000000008aff4a05eaed7866--