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

  
 
  

home | help
DROP FOR...A WRAPPER(7)   PostgreSQL 18.6 Documentation  DROP FOR...A 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 exe-
     cute  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 no-
	 tice 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 de-
	 pend on those objects (see Section 5.15).

     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 EX-
     ISTS 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 18.6 		      2026		 DROP FOR...A WRAPPER(7)

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

home | help