Re: Trick to create alias/mirror table

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Trick to create alias/mirror table
Дата
Msg-id CAAPsdhfjafr4zOWN7nXFmd5uaga_JCw7QECiRCnpN-giRRENRg@mail.gmail.com
обсуждение исходный текст
Ответ на Trick to create alias/mirror table  (intmail01 <intmail01@gmail.com>)
Список 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

В списке pgsql-sql по дате отправления: