Advertisement
Guest User

Untitled

a guest
May 26th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. CREATE EXTENSION postgres_fdw;
  2. CREATE EXTENSION dblink;
  3.  
  4. CREATE SERVER {{server_alias}} FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '{{remote_ip}}', dbname '{{remote_db}}', port '5432');
  5. CREATE USER MAPPING FOR {{current_db_user}} SERVER {{server_alias}} OPTIONS (user '{{remote_db_user}}', password '{{remote_db_password}}');
  6.  
  7. SELECT * FROM dblink('{{server_alias}}', 'SELECT 100500') AS t(test int);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement