Search PostgreSQL documentation

CompatibilityManual ChaptersPG18Compatibility CONNECT is specified in the SQL standard, but the format of the connection parameters is implementation-specific.Compatibility CompatibilityManual ChaptersPG18Compatibility DEALLOCATE DESCRIPTOR is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DECLARE STATEMENT is an extension of the SQL standard, but can be used in famous DBMSs.Compatibility CompatibilityManual ChaptersPG18Compatibility DECLARE is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DESCRIBE is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DISCONNECT is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility EXECUTE IMMEDIATE is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility GET DESCRIPTOR is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility OPEN is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility PREPARE is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility SET AUTOCOMMIT is an extension of PostgreSQL ECPG.Compatibility CompatibilityManual ChaptersPG18Compatibility SET CONNECTION is specified in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility SET DESCRIPTOR is specified in the SQL standard.Compatibility 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