Post #1725

PostgresFDW orqali boshqa serverga ulanish: Doc -> https://www.postgresql.org/docs/current/postgres-fdw.html Extensionni yoqish CREATE EXTENSION postgres_fdw; Server yaratish: create server server_name foreign data wrapper postgres_fdw options (host 'host_name', port '5432', dbname 'db_name'); User mapping yaratish: create user mapping for user_name server server_name options (user 'server_user_name', password 'server_user_passwd'); Tableni import qilish: IMPORT FOREIGN SCHEMA server_schema_name LIMIT TO (table_name) FROM SERVER server_name INTO schema_name;