Re: Trick to create alias/mirror table

From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
To: intmail01 <intmail01(at)gmail(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Trick to create alias/mirror table
Date: 2024-07-08 11:55:37
Message-ID: CAAPsdhfjafr4zOWN7nXFmd5uaga_JCw7QECiRCnpN-giRRENRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message shammat 2024-07-08 12:09:30 Re: Trick to create alias/mirror table
Previous Message intmail01 2024-07-08 11:27:37 Trick to create alias/mirror table