Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DROP FOREIGN DATA WRAPPEPostgreSQL 9.6.19 DocumentDROPnFOREIGN DATA WRAPPER(7)

NAME
       DROP_FOREIGN_DATA_WRAPPER - remove a foreign-data wrapper

SYNOPSIS
       DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [ CASCADE |	RESTRICT ]

DESCRIPTION
       DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To
       execute this command, the current user must be the owner	of the
       foreign-data wrapper.

PARAMETERS
       IF EXISTS
	   Do not throw	an error if the	foreign-data wrapper does not exist. A
	   notice is issued in this case.

       name
	   The name of an existing foreign-data	wrapper.

       CASCADE
	   Automatically drop objects that depend on the foreign-data wrapper
	   (such as foreign tables and servers), and in	turn all objects that
	   depend on those objects (see	Section	5.13, "Dependency Tracking",
	   in the documentation).

       RESTRICT
	   Refuse to drop the foreign-data wrapper if any objects depend on
	   it. This is the default.

EXAMPLES
       Drop the	foreign-data wrapper dbi:

	   DROP	FOREIGN	DATA WRAPPER dbi;

COMPATIBILITY
       DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The IF
       EXISTS clause is	a PostgreSQL extension.

SEE ALSO
       CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), ALTER
       FOREIGN DATA WRAPPER (ALTER_FOREIGN_DATA_WRAPPER(7))

PostgreSQL 9.6.19		     2020	  DROP FOREIGN DATA WRAPPER(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | EXAMPLES | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DROP_FOREIGN_DATA_WRAPPER&sektion=7&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help