Search PostgreSQL documentation

CompatibilityManual ChaptersPG18Compatibility The TYPE command is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The VAR command is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility WHENEVER is specified in the SQL standard, but most of the actions are PostgreSQL extensions.Compatibility CompatibilityManual ChaptersPG18F.17.6. Compatibility As of PostgreSQL 9.0, hstore uses a different internal representation than previous versions. This presents no obstacle for dump/restore upgrades since the text represe…Compatibility CompatibilityManual ChaptersPG18Compatibility This command is a PostgreSQL extension present for historical reasons. ROLLBACK is the equivalent standard SQL command.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER AGGREGATE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER COLLATION statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER CONVERSION statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility The ALTER DATABASE statement is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER DEFAULT PRIVILEGES statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER DOMAIN conforms to the SQL standard, except for the OWNER, RENAME, SET SCHEMA, and VALIDATE CONSTRAINT variants, which are PostgreSQL extensions. The NOT VALID clause of …Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER EVENT TRIGGER statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER EXTENSION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED), except that the HANDLER, VALIDATOR, OWNER TO, and RENAME clauses are extensions.Compatibility CompatibilityManual ChaptersPG18Compatibility The forms ADD, DROP, and SET DATA TYPE conform with the SQL standard. The other forms are PostgreSQL extensions of the SQL standard. Also, the ability to specify more than one …Compatibility CompatibilityManual ChaptersPG18Compatibility This statement is partially compatible with the ALTER FUNCTION statement in the SQL standard. The standard allows more properties of a function to be modified, but does not pro…Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER GROUP statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER INDEX is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER LANGUAGE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER LARGE OBJECT statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER MATERIALIZED VIEW is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER OPERATOR CLASS statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER OPERATOR statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER OPERATOR FAMILY statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER POLICY is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This statement is partially compatible with the ALTER PROCEDURE statement in the SQL standard. The standard allows more properties of a procedure to be modified, but does not p…Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER PUBLICATION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The ALTER ROLE statement is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This statement is partially compatible with the ALTER ROUTINE statement in the SQL standard. See under ALTER FUNCTION and ALTER PROCEDURE for more details. Allowing routine nam…Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER RULE is a PostgreSQL language extension, as is the entire query rewrite system.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER SCHEMA statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER SEQUENCE conforms to the SQL standard, except for the AS, START WITH, OWNED BY, OWNER TO, RENAME TO, and SET SCHEMA clauses, which are PostgreSQL extensions.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The OWNER TO and RENAME forms are PostgreSQL extensions.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER STATISTICS command in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER SUBSCRIPTION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The ALTER SYSTEM statement is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The forms ADD [COLUMN], DROP [COLUMN], DROP IDENTITY, RESTART, SET DEFAULT, SET DATA TYPE (without USING), SET GENERATED, and SET sequence_option conform with the SQL standard.…Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER TABLESPACE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility ALTER TRIGGER is a PostgreSQL extension of the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no ALTER TEXT SEARCH CONFIGURATION statement in the SQL standard.Compatibility