Postgres Pro
Downloads
Home   >   mailing lists

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

From Kashif Zeeshan
Subject Re: Trick to create alias/mirror table
Date
Msg-id CAAPsdhfjafr4zOWN7nXFmd5uaga_JCw7QECiRCnpN-giRRENRg@mail.gmail.com
Whole thread Raw
In response to Trick to create alias/mirror table  (intmail01 <intmail01@gmail.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

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