A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.

dblink Connectivity Functions

The PostgreSQL dblink module provides simple connections to other Greenplum Database databases from installations with the same major version number residing either on the same database host, or on a remote host. Greenplum Database provides dblink support for database users to perform short ad hoc queries in other databases. It is not intended as a replacement for external tables or administrative tools such as gpcopy.

Before you can use dblink functions, run the installation script $GPHOME/share/postgresql/contrib/dblink.sql in each database where you want the ability to query other databases:

$ psql -d testdb -f $GPHOME/share/postgresql/contrib/dblink.sql

See dblink Functions for basic information about using dblink to query other databases. See dblink in the PostgreSQL documentation for more information about individual functions.