Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE SERVER myremotedb FOREIGN DATA WRAPPER
- dblink_fdw OPTIONS (host 'myremotedb.123456.eu-west-1.rds.amazonaws.com', port '5432', dbname 'my_db');
- CREATE USER MAPPING FOR treex SERVER myremotedb OPTIONS (user 'foouser', password '1234');
- GRANT USAGE ON FOREIGN SERVER myremotedb TO foouser;
- SELECT dblink_connect('myremotedb', 'host=myremotedb.123456.eu-west-1.rds.amazonaws.com , port=5432 , user=foouser , password=1234 , dbname=mwu');
- select * from dblink('myremotedb', 'SELECT * FROM my_data') AS T(id integer, name text);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement