EXTENSION dblink and postgres_fdw

Download postgresql eBook

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

Related Examples

Stats

376 Contributors: 2
Thursday, March 23, 2017
Licensed under: CC-BY-SA

Not affiliated with Stack Overflow
Rip Tutorial: info@zzzprojects.com

Download eBook