Search PostgreSQL documentation

CompatibilityManual ChaptersPG18Compatibility There is no DROP AGGREGATE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility The DROP CAST command conforms to the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility The DROP COLLATION command conforms to the SQL standard, apart from the IF EXISTS option, which is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP CONVERSION statement in the SQL standard, but a DROP TRANSLATION statement that goes along with the CREATE TRANSLATION statement that is similar to the CREATE …Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP DATABASE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to the SQL standard, except for the IF EXISTS option, which is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP EVENT TRIGGER statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP EXTENSION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command, and apart from the IF EXISTS option, which …Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to the SQL standard, with these PostgreSQL extensions: The standard only allows one function to be dropped per command. The IF EXISTS option The ability t…Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP GROUP statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP INDEX is a PostgreSQL language extension. There are no provisions for indexes in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP LANGUAGE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP MATERIALIZED VIEW is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP OPERATOR CLASS statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP OPERATOR statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP OPERATOR FAMILY statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP POLICY is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to the SQL standard, with these PostgreSQL extensions: The standard only allows one procedure to be dropped per command. The IF EXISTS option is an extens…Compatibility CompatibilityManual ChaptersPG18Compatibility DROP PUBLICATION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The SQL standard defines DROP ROLE, but it allows only one role to be dropped at a time, and it specifies different privilege requirements than PostgreSQL uses.Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to the SQL standard, with these PostgreSQL extensions: The standard only allows one routine to be dropped per command. The IF EXISTS option is an extensio…Compatibility CompatibilityManual ChaptersPG18Compatibility DROP RULE is a PostgreSQL language extension, as is the entire query rewrite system.Compatibility CompatibilityManual ChaptersPG18Compatibility 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 …Compatibility CompatibilityManual ChaptersPG18Compatibility DROP SEQUENCE conforms to the SQL standard, except that the standard only allows one sequence to be dropped per command, and apart from the IF EXISTS option, which is a Postgre…Compatibility CompatibilityManual ChaptersPG18Compatibility DROP SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP STATISTICS command in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP SUBSCRIPTION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL …Compatibility CompatibilityManual ChaptersPG18Compatibility DROP TABLESPACE is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This form of DROP TRANSFORM is a PostgreSQL extension. See CREATE TRANSFORM for details.Compatibility CompatibilityManual ChaptersPG18Compatibility The DROP TRIGGER statement in PostgreSQL is incompatible with the SQL standard. In the SQL standard, trigger names are not local to tables, so the command is simply DROP TRIGGE…Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP TEXT SEARCH CONFIGURATION statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP TEXT SEARCH DICTIONARY statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP TEXT SEARCH PARSER statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility This command is similar to the corresponding command in the SQL standard, apart from the IF EXISTS option, which is a PostgreSQL extension. But note that much of the CREATE TYP…Compatibility CompatibilityManual ChaptersPG18Compatibility The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause is a PostgreSQL extension.Compatibility