Dblink postgres
Jump to navigation
Jump to search
https://dbaclass.com/article/how-to-create-database-link-in-postgres/
create users in function via dblink
create role tester1 with superuser login password 'tester1';
create database tester1 owner tester1;
dblink_connect('hostaddr=127.0.0.1 port=5432 dbname=tester1 user=tester1 password=tester1');
CREATE USER dblinkuser WITH PASSWORD 'dblinkuser';