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.
Parent topic: Installing Optional Extensions