centos man page for drop_schema

Query: drop_schema

OS: centos

Section: 7

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

DROP
SCHEMA(7) PostgreSQL 9.2.7 Documentation DROP SCHEMA(7)
NAME
DROP_SCHEMA - remove a schema
SYNOPSIS
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SCHEMA removes schemas from the database. A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even if he does not own some of the objects within the schema.
PARAMETERS
IF EXISTS Do not throw an error if the schema does not exist. A notice is issued in this case. name The name of a schema. CASCADE Automatically drop objects (tables, functions, etc.) that are contained in the schema. RESTRICT Refuse to drop the schema if it contains any objects. This is the default.
EXAMPLES
To remove schema mystuff from the database, along with everything it contains: DROP SCHEMA mystuff CASCADE;
COMPATIBILITY
DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER SCHEMA (ALTER_SCHEMA(7)), CREATE SCHEMA (CREATE_SCHEMA(7)) PostgreSQL 9.2.7 2014-02-17 DROP SCHEMA(7)
Related Man Pages
drop_operator_family(7) - centos
drop_schema(7) - suse
drop_table(7) - suse
drop_table(7) - osx
drop_table(7) - linux
Similar Topics in the Unix Linux Community
find a column in a schema
how to Declare 5 values to one variable with OR operation
Help writing SQL query
Passing string from bash to sqlplus
awk print not working properly