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