Postgres Pro
Downloads
Home   >   mailing lists

Re: Trick to create alias/mirror table - Mailing list pgsql-sql

From Achilleas Mantzios - cloud
Subject Re: Trick to create alias/mirror table
Date
Msg-id 6aaf80f9-41b5-9c57-b474-fca88aa2ba22@cloud.gatewaynet.com
Whole thread Raw
In response to Trick to create alias/mirror table  (intmail01 <intmail01@gmail.com>)
List pgsql-sql
Tree view


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

pgsql-sql by date:

Previous
From: shammat@gmx.net
Date:
Subject: Re: Trick to create alias/mirror table
Next
From: intmail01
Date:
Subject: Re: Trick to create alias/mirror table