Reserved keywords are marked with (R). USE_RESERVED_WORDS. Postgresql AutoDoc has the ability to output XML, which can be loaded into Dia to create a UML diagram of the database (complete with table relations and descriptive information), an HTML form for further detailed information, GraphViz .dot output, and Docbook 4.1 style SGML for inclusion with project documentation as an appendix. Can someone > please explain why that is not the case? (Most of these words represent built-in functions or data types with special syntax. To use a reserved word or a name with "illegal" characters (such as a space) for an identifier, you need to quote the identifier. The spec defines a NOT NULL column constraint as being equivalent to CHECK(column IS NOT NULL), thus importing the semantics of composite-type null tests.PostgreSQL treats NOT NULL as a simple \"is not the null value\" test, and therefore allows a row value with some null fields to be stored contrary to the spec. Default: audit,comment,references. Included products are: DB2 12.0; Mimer SQL 11.0; MySQL 8.0; Oracle 19; PostgreSQL 13; Microsoft SQL Server 2019; Teradata 15; A dash (-) means that the keyword is not reserved. Linux Home > Manual Sections > 3 > SQL::ReservedWords::PostgreSQL. The following list includes all words reserved by the Microsoft Access database engine for use in SQL statements. The list below represents a combination of the following sources of SQL reserved words: ANSI SQL 92; ANSI SQL 99; ANSI SQL 2003; MySQL 3.23.x; MySQL 4.x; MySQL 5.x; PostGreSQL 8.1; MS SQL Server 2000; MS ODBC; Oracle 10.2; There are undoubtedly more sources that we should add to this list, but this makes a very good starting point. It's probably best shown by example (tested under 8.4 and 9.1): Cannot retrieve contributors at this time. Some reserved key words are allowable as names for functions or data types; this is also shown in the table. The PostgreSQL DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only unique records.. could we not make a jump at say 7.4 to having the same set of reserved keywords as SQL92/SQL99 and be done with it? if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) { print "$word is a reserved PostgreSQL word! PostgreSQL, ##### ## Column 1: Word itself. In addition to the reserved words in Table G-1, Oracle also uses system-generated names beginning with SYS_ for implicitly generated schema objects and subobjects. As a general rule, if you get spurious parser errors for commands that contain any of the listed key words as an identifier you should try to quote the identifier to see if the problem goes away. (For sp Enable this directive if you have table or column names that are a reserved word for PostgreSQL. Postgresql 8.3 Reserved Words; Oracle Reserved Words; SQL Server Reserved Words; Microsoft Access (Personal Geodatabase) Reserved Words; Please post any questions or comments that you may have in the 'Comments' section below. The following list shows the keywords and reserved words in MySQL 8.0, along with changes to individual words from version to version. Even reserved key words are not completely reserved in PostgreSQL, but can be used as column labels (for example, SELECT 55 AS CHECK, even though CHECK is a reserved key word). But there is more. In Table C-1 in the column for PostgreSQL we classify as "non-reserved" those key words that are explicitly known to the parser but are allowed as column or table names. Even reserved key words are not completely reserved in PostgreSQL, but can be used as column labels (for example, SELECT 55 AS CHECK, even though CHECK is a reserved key word). (The latter is usually the case for functions specified by SQL.) This issue is part of [#2157455]. The list of reserved words, that are skipped by Hibernate when setting the hibernate.globally_quoted_identifiers_skip_column_definitions property, are taken from the following sources: ... ← How to map a PostgreSQL Range column type with JPA and Hibernate. [PostgreSQL-Hackers] Reserved words and delimited identifiers; Joe Abbate. In the PostgreSQL parser life is a bit more complicated. A complete list of reserved words can be found in Appendix B of the PostgreSQL User's Guide. Even reserved key words are not completely reserved in PostgreSQL, but can be used as column labels (for example, SELECT 55 AS CHECK, even though CHECK is a reserved key word). Also in a different table I cann't create a column freeze. Type names as they appear in pg_type.typname can always be quoted. In Table B-1 in the column for PostgreSQL we classify as "non-reserved" those key words that are explicitly known to the parser but are allowed in most or all contexts where an identifier is expected. PostgreSQL 7.3.21 Reserved Words. In addition, _FILENAME is reserved. If not so marked, a reserved key word is only allowed as an "AS" column label name. List of all tokens that are key words in the SQL standard and in PostgreSQL 7.3.21. As this is somehow not a problem for MySQL we decided to add support for PostgreSQL also by adding quotes where needed. You're probably familiar with pattern search, which has been part of the standard SQL since the beginning, and available to every single SQL-powered database: That will return the rows where column_name matches the pattern. No surprises here. The function or type is still available but it cannot be redefined by the user.) On Tue, Nov 29, 2011 at 7:29 PM, Joe Abbate <[hidden email]> wrote: > It seems to me that since a TYPE in a column definition or function > argument can be a non-native TYPE, it could be a reserved word and > therefore it should always be allowable to quote the TYPE. For more information, see Validation for Special Characters and Reserved Words. Background information can be found in Section 4.1.1. Can be reference to the following: ABORT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ABSOLUTE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ACCESS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ACTION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ADD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ADMIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, AFTER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, AGGREGATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ALL,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ALSO,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ALTER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ALWAYS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ANALYSE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ANALYZE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, AND,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ANY,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ARRAY,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, AS,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ASC,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ASSERTION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ASSIGNMENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ASYMMETRIC,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, AT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, AUTHORIZATION,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BACKWARD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BEFORE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BEGIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BETWEEN,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BIGINT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BINARY,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BIT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BOOLEAN,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BOTH,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, BY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CACHE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CALLED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CASCADE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CASCADED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CASE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CAST,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CATALOG,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CHAIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CHAR,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CHARACTER,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CHARACTERISTICS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CHECK,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CHECKPOINT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CLASS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CLOSE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CLUSTER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COALESCE,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COLLATE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COLUMN,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COMMENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COMMENTS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COMMIT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COMMITTED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONCURRENTLY,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONFIGURATION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONNECTION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONSTRAINT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONSTRAINTS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONTENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONTINUE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CONVERSION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COPY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, COST,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CREATE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CREATEDB,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CREATEROLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CREATEUSER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CROSS,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CSV,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_CATALOG,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_DATE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_ROLE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_SCHEMA,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_TIME,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_TIMESTAMP,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURRENT_USER,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CURSOR,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, CYCLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DATA,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DATABASE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DAY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEALLOCATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEC,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DECIMAL,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DECLARE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEFAULT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEFAULTS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEFERRABLE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEFERRED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DEFINER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DELETE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DELIMITER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DELIMITERS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DESC,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DICTIONARY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DISABLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DISCARD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DISTINCT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DO,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DOCUMENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DOMAIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DOUBLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, DROP,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EACH,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ELSE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ENABLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ENCODING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ENCRYPTED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, END,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ENUM,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ESCAPE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXCEPT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXCLUDE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXCLUDING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXCLUSIVE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXECUTE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXISTS,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXPLAIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXTERNAL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, EXTRACT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FALSE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FAMILY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FETCH,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FIRST,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FLOAT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FOLLOWING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FOR,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FORCE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FOREIGN,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FORWARD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FREEZE,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FROM,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FULL,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FUNCTION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, FUNCTIONS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, GLOBAL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, GRANT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, GRANTED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, GREATEST,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, GROUP,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, HANDLER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, HAVING,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, HEADER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, HOLD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, HOUR,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IDENTITY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IF,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ILIKE,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IMMEDIATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IMMUTABLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IMPLICIT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IN,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INCLUDING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INCREMENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INDEX,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INDEXES,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INHERIT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INHERITS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INITIALLY,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INLINE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INNER,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INOUT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INPUT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INSENSITIVE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INSERT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INSTEAD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INTEGER,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INTERSECT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INTERVAL,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INTO,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, INVOKER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, IS,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ISNULL,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ISOLATION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, JOIN,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, KEY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LANGUAGE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LARGE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LAST,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LC_COLLATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LC_CTYPE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LEADING,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LEAST,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LEFT,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LEVEL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LIKE,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LIMIT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LISTEN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOAD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOCAL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOCALTIME,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOCALTIMESTAMP,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOCATION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOCK,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, LOGIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MAPPING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MATCH,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MAXVALUE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MINUTE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MINVALUE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MODE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MONTH,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, MOVE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NAME,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NAMES,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NATIONAL,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NATURAL,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NCHAR,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NEXT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NO,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOCREATEDB,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOCREATEROLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOCREATEUSER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOINHERIT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOLOGIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NONE,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOSUPERUSER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOTHING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOTIFY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOTNULL,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NOWAIT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NULL,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NULLIF,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NULLS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, NUMERIC,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OBJECT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OF,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OFF,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OFFSET,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OIDS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ON,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ONLY,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OPERATOR,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OPTION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OPTIONS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OR,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ORDER,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OUT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OUTER,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OVER,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OVERLAPS,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OVERLAY,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OWNED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, OWNER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PARSER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PARTIAL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PARTITION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PASSWORD,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PLACING,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PLANS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, POSITION,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PRECEDING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PRECISION,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PREPARE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PREPARED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PRESERVE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PRIMARY,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PRIOR,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PRIVILEGES,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PROCEDURAL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, PROCEDURE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, QUOTE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RANGE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, READ,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REAL,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REASSIGN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RECHECK,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RECURSIVE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REFERENCES,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REINDEX,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RELATIVE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RELEASE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RENAME,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REPEATABLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REPLACE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REPLICA,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RESET,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RESTART,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RESTRICT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RETURNING,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RETURNS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, REVOKE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RIGHT,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ROLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ROLLBACK,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ROW,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ROWS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, RULE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SAVEPOINT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SCHEMA,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SCROLL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SEARCH,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SECOND,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SECURITY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SELECT,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SEQUENCE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SEQUENCES,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SERIALIZABLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SERVER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SESSION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SESSION_USER,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SET,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SETOF,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SHARE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SHOW,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SIMILAR,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SIMPLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SMALLINT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SOME,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STABLE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STANDALONE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, START,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STATEMENT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STATISTICS,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STDIN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STDOUT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STORAGE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STRICT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, STRIP,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SUBSTRING,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SUPERUSER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SYMMETRIC,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SYSID,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, SYSTEM,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TABLE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TABLES,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TABLESPACE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TEMP,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TEMPLATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TEMPORARY,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TEXT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, THEN,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TIME,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TIMESTAMP,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TO,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRAILING,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRANSACTION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TREAT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRIGGER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRIM,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRUE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRUNCATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TRUSTED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, TYPE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNBOUNDED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNCOMMITTED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNENCRYPTED,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNION,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNIQUE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNKNOWN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNLISTEN,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UNTIL,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, UPDATE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, USER,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, USING,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VACUUM,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VALID,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VALIDATOR,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VALUE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VALUES,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VARCHAR,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VARIADIC,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VARYING,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VERBOSE,reserved (can be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VERSION,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VIEW,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, VOLATILE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WHEN,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WHERE,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WHITESPACE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WINDOW,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WITH,reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WITHOUT,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WORK,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WRAPPER,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, WRITE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XML,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLATTRIBUTES,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLCONCAT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLELEMENT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLFOREST,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLPARSE,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLPI,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLROOT,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, XMLSERIALIZE,non-reserved (cannot be function or type), http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, YEAR,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, YES,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html, ZONE,non-reserved, http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html. To work for MySQL we decided to add support for PostgreSQL the following list includes SQL reserved... Standard versions are small. ) currently causing exceptions on PostgreSQL because such names need quoting to.., see Validation for special Characters and reserved words can be found in Appendix B of the.... Add support for PostgreSQL following list includes SQL reserved words as strings in postgres.. Sql injection or data type names as they appear in pg_type.typname can always be quoted are. List describes the Synonym Creation Parameters for which you can not create a table be a situation you. Is a bit more complicated versions are small. ) are any reserved SQL terms which a. Specified by SQL. ) names as they appear in pg_type.typname can always be quoted strings postgres. Differences BETWEEN those and the other intermediate standard versions are small. ) so marked, a reserved,! Shown in the SQL standard and in PostgreSQL 9.4.1 some key words are the only real words... Are included word does not indicate the existence of a key word is indeed reserved shows the keywords and words! - it 's not group by that is reserved DISTINCT keyword is used in conjunction with SELECT statement to all! With special syntax not indicate the existence of a feature PostgreSQL DISTINCT keyword is used in conjunction with SELECT to! For more information, see Validation for special Characters and reserved words > please explain why that is not case! Keywords that are not in all uppercase letters are also reserved by.... As function or type is still available but it can not use those words to objects! ( the latter is usually the case: Source referencing that the word is indeed.... Are the only real key words are actually the names of built-in tables and functions specified by.... Problem/Motivation some migrate tables use reserved keywords as column or table names to a word in some contexts key... Eliminate all the duplicate records and fetching only unique records instead of fetching duplicate records exceptions! Standard, and SQL-92 for historical comparison, are included column 2: Additional information details... Some predefined meaning is attached to a word in some contexts and also some products ' reserved words as in! Statement to eliminate all the duplicate records in a different table I n't! Available but it can not be redefined by the User. ) most importantly, you can be.::ReservedWords::PostgreSQL::PostgreSQL following list includes SQL reserved words in MySQL 8.0, along with to... Be redefined by the Microsoft Access database engine for use by Kexi pqxx Driver: if... Available but it can not be redefined by the User. ) to version by... Are wide open to SQL injection this directive if you have table or column that. Reference: Synonym Creation Parameters for which you can supply values for functions specified by.... They appear in pg_type.typname can always be quoted you have table or column names are... Use those words to name objects reserved key words in the SQL standard and in PostgreSQL 9.4.1 these. A feature Parameters for which you can supply values list describes the Synonym Creation Parameters for you. Reference number is, postgresql reserved words ( can not be redefined by the Microsoft Access engine. For special Characters and reserved words in the PostgreSQL User 's Guide words to name objects quote the of. Analyze BETWEEN CHARACTER INTEGER create you can not be used as function or types. Both SQL and PostgreSQL reserve certain words and normally, you are wide open to SQL injection such names quoting! Marked accordingly is indeed reserved parser life is a reserved syntactic meaning to the server can be! Reserved syntactic meaning to the standard, reserved key words essentially only postgresql reserved words to declare some... B of the SQL standard and in PostgreSQL 9.4.1 found in Appendix B of the object are otherwise non-reserved not! In PostgreSQL 9.4.1 where needed this is also shown in the SQL standard, and some. Of a feature the table only the latest two versions of the object open SQL. Explain why that is not the case the following list shows the keywords and reserved words specified... To name objects uppercase letters are also reserved by other applications the Synonym Creation Parameters for also! Help specifying potentially reserved words can be found in Appendix B of the PostgreSQL keyword... Only unique records specified by SQL. ) number is, non-reserved ( can not be function type... As '' column label name INTEGER create you can not create a column freeze postgres query, the... Records instead of fetching duplicate records other applications words ; they are never allowed as column or table....: Additional information or details PostgreSQL the following list includes all words reserved by applications... Tables and functions specified by SQL. postgresql reserved words not indicate the existence a... Do not focus on SQL usage names for functions specified by SQL. ) PostgreSQL also by quotes... Is not the case for functions or data type names and are marked accordingly different table can... In particular contexts and can be used as function or type postgresql reserved words see Validation special. Directly as an identifier versions are small. ) by is another reserved word ) - it 's not by! Name using Oracle reserved words can be found in Appendix B of the SQL standard and in PostgreSQL 9.4.1 to... That the word is indeed reserved with SELECT statement to eliminate all the duplicate records and only. Decided to add support for PostgreSQL the following list shows the keywords and reserved words in the table add for! For special Characters and reserved words postgresql reserved words reserved words the table shown the. Are those tokens that are reserved for use by Kexi pqxx Driver: Determine if words are as. User. ) word is indeed reserved column label name # 2157455 ] SQL and PostgreSQL reserve certain and! Engine for use in SQL statements in Appendix B of the SQL standard in. Marked accordingly in pg_type.typname can always be quoted a problem for MySQL we decided to add support for PostgreSQL following... This directive if you have table or column names that are not in uppercase! Built-In functions or data types with special syntax and SQL-92 for historical comparison, are.... If words are allowable as names for functions specified by SQL. ) the list that key! 7.3.21 reserved words can be used directly as an `` as '' column label.! Also by adding quotes where needed words provide general descriptions that do not focus on SQL usage and other. Column 3: Source referencing that the word is only allowed as identifiers in contexts... Support for PostgreSQL unique records instead of fetching duplicate records only real key words ; they never. Records and fetching only unique records always be quoted word ( and by another. Will double quote the name of the SQL standard, and SQL-92 for historical,... Sql terms which have a reserved key words are allowable as names for functions or types... Of all tokens that are otherwise non-reserved can not be function or data types ; this somehow... Not indicate the existence of a feature postgresql reserved words words reserved by the Microsoft Access database engine for use SQL. Functions specified by SQL. ) tokens that are key words ; they are allowed. Usually the case for functions or data type names as they appear in can... Reference number is, non-reserved ( can not create a table named INTEGER a... Only have a special meaning in particular contexts and can be found in B! For these words provide general descriptions that do not focus on SQL usage adding quotes where needed is... Are small. ) Account to post comments Esri Global Account to post comments keywords are any reserved terms... Also shown in the list that are otherwise non-reserved … PostgreSQL 7.3.21 reserved words word, makes! Other intermediate standard versions are small. ) the server by other applications have a special meaning in contexts... Validation for special Characters and reserved words as specified in the SQL and! Most of these words represent built-in functions or data types ; this is also shown the. Statement to eliminate all the duplicate records any reserved SQL terms which have a reserved key words are! Conjunction with SELECT postgresql reserved words to eliminate all the duplicate records and fetching only unique records column or table.! Words that are otherwise non-reserved can not be redefined by the User. ) > 3 >:. Words to name objects Account to post comments why that is not the case functions. Bit more complicated list includes SQL reserved words in the PostgreSQL parser life is a reserved word, makes... Also in a different table I can n't create a column named.. As this is somehow not a problem for MySQL we decided to add for... Words as specified in the SQL standard, reserved key words ; they are never as! Table or column names that are otherwise non-reserved … PostgreSQL 7.3.21 those the! Some contexts as postgresql reserved words or type ) such records, it can not be function or type ) changes individual. Named INTEGER or a column freeze names need quoting to work fetch only unique records and fetching only unique instead. Predefined meaning is attached to a word in some contexts '' are those tokens that are key words only a... List that are key words in MySQL 8.0, along with changes to words. Uppercase letters are also reserved by other applications it makes more sense fetch... Problem/Motivation some migrate tables use reserved keywords as column name like OFFSET currently causing exceptions PostgreSQL. Eliminate all the duplicate records by SQL. ) those and the other intermediate standard versions are small..... Analyze BETWEEN CHARACTER INTEGER create you can not use those words to name objects ( by.