postgresql EXTENSION dblink and postgres_fdw
Syntax
-
dblink ('dbname = name_db_distance port = PortOfDB host = HostOfDB user = usernameDB password = passwordDB', 'MY QUESRY')
-
dbname = name of the database
-
port = Port Of the database
-
host = Host Of the database
-
user = username of the database
-
password = password of the database',
-
MY QUESRY = this can be any operation i want to do SELECT, INSERT, ...
