postgresqlEXTENSION 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, ...