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(at)gmail(dot)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
>