Horton

Re: Trick to create alias/mirror table

Kashif Zeeshan <kashi.zeeshan@gmail.com>

View thread View on postgr.es
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
To: intmail01 <intmail01@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Date: 2024-07-08T11:55:37Z
Lists: pgsql-sql 
Hi

You can use following options

1. Postgres FDW
2. Materialized Views


Regards
Kashif Zeeshan

On Mon, Jul 8, 2024 at 4:25 PM intmail01 <intmail01@gmail.com> 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.
> 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
>