Search PostgreSQL documentation

CompatibilityManual ChaptersPG18Compatibility The CREATE FOREIGN TABLE command largely conforms to the SQL standard; however, much as with CREATE TABLE, NULL constraints and zero-column foreign tables are permitted. The ab…Compatibility CompatibilityManual ChaptersPG18Compatibility A CREATE FUNCTION command is defined in the SQL standard. The PostgreSQL implementation can be used in a compatible way but has many extensions. Conversely, the SQL standard sp…Compatibility CompatibilityManual ChaptersPG18Compatibility There is no CREATE GROUP statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE INDEX is a PostgreSQL language extension. There are no provisions for indexes in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE LANGUAGE is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE MATERIALIZED VIEW is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE OPERATOR CLASS is a PostgreSQL extension. There is no CREATE OPERATOR CLASS statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE OPERATOR is a PostgreSQL extension. There are no provisions for user-defined operators in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE OPERATOR FAMILY is a PostgreSQL extension. There is no CREATE OPERATOR FAMILY statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE POLICY is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility A CREATE PROCEDURE command is defined in the SQL standard. The PostgreSQL implementation can be used in a compatible way but has many extensions. For details see also CREATE FU…Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE PUBLICATION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The CREATE ROLE statement is in the SQL standard, but the standard only requires the syntax CREATE ROLE name [ WITH ADMIN role_name ] Multiple initial administrators, and all t…Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE RULE is a PostgreSQL language extension, as is the entire query rewrite system.Compatibility CompatibilityManual ChaptersPG18Compatibility The SQL standard allows a DEFAULT CHARACTER SET clause in CREATE SCHEMA, as well as more subcommand types than are presently accepted by PostgreSQL. The SQL standard specifies …Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE SEQUENCE conforms to the SQL standard, with the following exceptions: Obtaining the next value is done using the nextval() function instead of the standard's NEXT VALUE …Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED).Compatibility CompatibilityManual ChaptersPG18Compatibility There is no CREATE STATISTICS command in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE SUBSCRIPTION is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The CREATE TABLE command conforms to the SQL standard, with exceptions listed below.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE TABLE AS conforms to the SQL standard. The following are nonstandard extensions: The standard requires parentheses around the subquery clause; in PostgreSQL, these paren…Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE TABLESPACE is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility This form of CREATE TRANSFORM is a PostgreSQL extension. There is a CREATE TRANSFORM command in the SQL standard, but it is for adapting data types to client languages. That us…Compatibility CompatibilityManual ChaptersPG18Compatibility The CREATE TRIGGER statement in PostgreSQL implements a subset of the SQL standard. The following functionalities are currently missing: While transition table names for AFTER …Compatibility CompatibilityManual ChaptersPG18Compatibility There is no CREATE TEXT SEARCH CONFIGURATION statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no CREATE TEXT SEARCH DICTIONARY statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no CREATE TEXT SEARCH PARSER statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no CREATE TEXT SEARCH TEMPLATE statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility The first form of the CREATE TYPE command, which creates a composite type, conforms to the SQL standard. The other forms are PostgreSQL extensions. The CREATE TYPE statement in…Compatibility CompatibilityManual ChaptersPG18Compatibility The CREATE USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED).Compatibility CompatibilityManual ChaptersPG18Compatibility CREATE OR REPLACE VIEW is a PostgreSQL language extension. So is the concept of a temporary view. The WITH ( ... ) clause is an extension as well, as are security barrier views…Compatibility CompatibilityManual ChaptersPG18Compatibility The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.Compatibility CompatibilityManual ChaptersPG18Compatibility The SQL standard allows cursors only in embedded SQL and in modules. PostgreSQL permits cursors to be used interactively. According to the SQL standard, changes made to insensi…Compatibility CompatibilityManual ChaptersPG18Compatibility This command conforms to the SQL standard, except that the USING and RETURNING clauses are PostgreSQL extensions, as is the ability to use WITH with DELETE.Compatibility CompatibilityManual ChaptersPG18Compatibility DISCARD is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DO statement in the SQL standard.Compatibility CompatibilityManual ChaptersPG18Compatibility DROP ACCESS METHOD is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility The DROP OWNED command is a PostgreSQL extension.Compatibility CompatibilityManual ChaptersPG18Compatibility There is no DROP AGGREGATE statement in the SQL standard.Compatibility