Foreign Data Wrapper

suggest change

To access complete schema of server db instead of single table. Follow below steps:

  1. Create EXTENSION :
CREATE EXTENSION postgres_fdw;
  1. Create SERVER :
```
CREATE SERVER server_name FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'host_ip', 
dbname 'db_name', port 'port_number');
```
  1. Create USER MAPPING:
```
CREATE USER MAPPING FOR CURRENT_USER
SERVER server_name
OPTIONS (user 'user_name', password 'password');
```
  1. Create new schema to access schema of server DB:
CREATE SCHEMA schema_name;
  1. Import server schema:
```
IMPORT FOREIGN SCHEMA schema_name_to_import_from_remote_db
FROM SERVER server_name
INTO schema_name;
```
  1. Access any table of server schema:
SELECT * FROM schema_name.table_name;

This can be used to access multiple schema of remote DB.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:



Table Of Contents