I'd like to create a simple materialized view from a table which lies in a different database. The two databases are on the same server.
What do I have to add to make the query access the foreign database and the table there?
CREATE MATERIALIZED VIEW mv_table_1 AS SELECT * FROM public.mv_table_1 --The schema & table from the different DB WITH DATA;
I tried using the fully qualified table name (db name before the schema name) but this results in an error:
References to other dbs are not implemented