Re: Trick to create alias/mirror table

Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>

From: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
To: pgsql-sql@lists.postgresql.org
Date: 2024-07-08T12:17:48Z
Lists: pgsql-sql
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