2.3.42 DROP DATABASE LINK

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

2 The SQL Language : 2.3 SQL Commands : 2.3.42 DROP DATABASE LINK

2.3.42 DROP DATABASE LINK

Name

DROP DATABASE LINK -- remove a database link

Synopsis

DROP [ PUBLIC ] DATABASE LINK name

Description

DROP DATABASE LINK drops existing database links. To execute this command you must be a superuser or the owner of the database link.

Parameters

name

The name of a database link to be removed.

PUBLIC

Indicates that name is a public database link.

Examples

Remove the public database link named, oralink:

DROP PUBLIC DATABASE LINK oralink;

Remove the private database link named, edblink:

DROP DATABASE LINK edblink;

See Also

CREATE DATABASE LINK

2 The SQL Language : 2.3 SQL Commands : 2.3.42 DROP DATABASE LINK