how to create database link in postgresql?
Load the 'dblink' extension using 'CREATE EXTENSION' command. On database 'goku', create a foreign server object using the 'CREATE SERVER' command. Here, you need to enter the details of the host, the remote database you intend to connect and the port on which PostgreSQL is running.