Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQnJe-00BfVh-Kl for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 12:17:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sQnJd-005T6S-8o for pgsql-sql@arkaria.postgresql.org; Mon, 08 Jul 2024 12:17:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQnJc-005T6K-W3 for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 12:17:57 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sQnJZ-0011Wy-TS for pgsql-sql@lists.postgresql.org; Mon, 08 Jul 2024 12:17:55 +0000 Content-Type: multipart/alternative; boundary="------------LLM3hhvXVZQr8AaSn6nHZU0t" Message-ID: <6aaf80f9-41b5-9c57-b474-fca88aa2ba22@cloud.gatewaynet.com> Date: Mon, 8 Jul 2024 15:17:48 +0300 MIME-Version: 1.0 Subject: Re: Trick to create alias/mirror table Content-Language: en-US To: pgsql-sql@lists.postgresql.org References: From: Achilleas Mantzios - cloud In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------LLM3hhvXVZQr8AaSn6nHZU0t Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 7/8/24 14:27, intmail01 wrote: > > > > Hi, > Looking for a trick to make something like an alias or a mirror table. > The alias can be updated. > View is not suitable because it is read only data. What? Check out the docs. Views can be perfectly modified. > The alias is always linked to the original table. When a modification > occurred in the original table this will be visible in all link tables. > > Thanks --------------LLM3hhvXVZQr8AaSn6nHZU0t Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit


On 7/8/24 14:27, intmail01 wrote:
Hi,
Looking for a trick to make something like an alias or a mirror table. The alias can be updated.

View is not suitable because it is read only data.
What? Check out the docs. Views can be perfectly modified.
The alias is always linked to the original table. When a modification occurred in the original table this will be visible in all link tables.

Thanks
--------------LLM3hhvXVZQr8AaSn6nHZU0t--