Can you refresh a materialized view from a materialized view on another server?

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема Can you refresh a materialized view from a materialized view on another server?
Дата
Msg-id CAOzAquJEm+eY6LAUoRoBBauvcDEg4dXD=YOSrMO9f-B3474VUw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can you refresh a materialized view from a materialized view on another server?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
My production server has a materialized view that is refreshed from a
mysql_fdw several times a day.

What I'd like to be able to do is refresh the materialized view on the
testbed server from the one on the production server so that they are
the same.  (Refreshing it from the MySQL server will result in one
that has records that have been added or updated rather than an exact
copy of the one on the production server.)

Mike Nolan
htfoot@gmail.com



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

Предыдущее
От: "Buoro, John"
Дата:
Сообщение: SSPI Feature Request
Следующее
От: Saksham Joshi
Дата:
Сообщение: Not able to grant access on pg_signal_backend on azure flexible server