Мастер: dbname@master=# \det Список сторонних таблиц Схема | Таблица | Сервер ----------+------------+----------- schema01 | table01_01 | remote_srv schema01 | table01_02 | remote_srv schema01 | table01_03 | remote_srv schema01 | table01_04 | remote_srv schema01 | table01_05 | remote_srv schema01 | table01_06 | remote_srv schema01 | table01_07 | remote_srv schema01 | table01_08 | remote_srv schema01 | table01_09 | remote_srv schema01 | table01_10 | remote_srv schema02 | table02_01 | remote_srv schema02 | table02_02 | remote_srv schema02 | table02_03 | remote_srv (13 строк) dbname@master=# Реплика: dbname@replika=# \det List of foreign tables Schema | Table | Server --------+-------+-------- (0 rows) dbname@replika=# А вот так выглядят таблички на реплике: dbname@replika=# \d schema01.table01_08 Foreign table "schema01.table01_08" Column | Type | Modifiers | FDW Options ---------+-----------------------------+-----------+------------- tbl_key | integer | | filed01 | character varying | | filed02 | character varying | | field03 | character varying | | field04 | integer | | ins_ts | timestamp without time zone | | Server: remote_srv FDW Options: (schema_name 'remote_schema') dbname@replika=#
Обсуждают сегодня