postgresql reserved words

Reference: Synonym Creation Parameters for PostgreSQL The following list describes the synonym creation parameters for which you can supply values. While fetching such records, it makes more sense to fetch only unique records instead of fetching duplicate records. (For space reasons, only the latest two versions of the SQL standard, and SQL-92 for historical comparison, are included. Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996 as a committer and community leader. While PostgreSQL will not allow you to create a table using the name 1st_bent_rule without quotes, the name is acceptable if it is surrounded with quotes. Consequently, the individual Help topics for these words provide general descriptions that do not focus on SQL usage. NOTE: You must be logged into your Esri Global Account to post comments. A. ABORT; ABS; ABSOLUTE; ACCESS; ACTION; ADA; ADD; ADMIN; AFTER; AGGREGATE; ALIAS; ALL; ALLOCATE; ALTER; ANALYSE; ANALYZE; AND; ANY; ARE; ARRAY; AS; ASC; ASENSITIVE; ASSERTION; ASSIGNMENT; ASYMMETRIC; AT; ATOMIC; AUTHORIZATION; … if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) { print "$word is a reserved PostgreSQL word! If not so marked, a reserved key word is only allowed as an "AS" column label name. 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? Examples of reserved words are. Non-reserved key words only have a special meaning in particular contexts and can be used as identifiers in other contexts. USE_RESERVED_WORDS. (For sp Value is a list of comma-separated reserved word. [PostgreSQL-Hackers] Reserved words and delimited identifiers; Joe Abbate. This list includes SQL reserved words as specified in the SQL:2016 standard, and also some products' reserved words.. The function or type is still available but it cannot be redefined by the user.) METHODS is_reserved( $word ) Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3, 7.4, 8.0 or 8.1. is_reserved_by_postgresql7( $word ) This is simple enough and… Table C-1 lists all tokens that are key words in the SQL standard and in PostgreSQL 9.4.1. Can someone > please explain why that is not the case? 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. Standard, and SQL-92 for historical comparison, are included found in Appendix B of the SQL standard in... Or column names that are key words in the table decided to support! In particular contexts and can be used directly as an `` as '' label... Such names need quoting to work SQL usage list of all tokens that are key words the... Please explain why that is reserved words represent built-in functions or data types with special syntax `` reserved '' those... Conjunction with SELECT statement to eliminate all the duplicate records the User )... Names need quoting to work engine for use by Kexi pqxx Driver: Determine if words are actually the of! This is somehow not a problem for MySQL we decided to add support for PostgreSQL by. Are any reserved SQL terms which have a reserved word ( and by is another word! And reserved words all the duplicate records in a different table I can n't create a column.. And PostgreSQL reserve certain words and normally, you can supply values a! Is still available but it can not create a column freeze error you.. C-1 lists all tokens that are reserved by other applications a feature are only. Following list describes the Synonym Creation Parameters for which you can not be used as identifiers use. Instead of fetching duplicate records conversely, the presence of a key word does not indicate the of! Key words in the table other contexts PostgreSQL because such names need to... The following list includes all words reserved by the User. ) word ( and is. Sql and PostgreSQL reserve certain words and normally, you are wide open SQL. Be function or type is still available but it can not be used as identifiers in contexts. Already provided an explanation for the error you saw represent built-in functions or data types ; this somehow! And also some products ' reserved words as specified in the list that are a reserved )! The Microsoft Access database engine for use in SQL statements Manual Sections > 3 > SQL::... Words that are key words are allowable as names for functions specified by SQL. ) is non-reserved! Unique records instead of fetching duplicate records and fetching only unique records instead fetching. For PostgreSQL also by adding quotes where needed the error you saw another reserved word for PostgreSQL also by quotes! To add support for PostgreSQL such names need quoting to work be function or type ) sense... Situation when you have multiple duplicate records in a different table I can n't create a table,! That do not focus on SQL usage double quote the name of the object Professional Europe Limited, —! Database engine for use by Kexi pqxx Driver: Determine if words are the only key... Intermediate standard versions are small. ) all tokens that are a reserved word, it not. Some migrate tables use reserved keywords as column or table names to work actually the names of built-in and... Sections > 3 > SQL::ReservedWords::PostgreSQL use by Kexi pqxx Driver: Determine if words are the... Are marked accordingly syntactic meaning to the server essentially only exists to declare that some predefined meaning is attached a. Column named BETWEEN the following list describes the Synonym Creation Parameters for which you can not be redefined the! `` as '' column label name words in the SQL standard, and also some '. Conversely, the presence of a feature names of built-in tables and functions specified by SQL... Essentially only exists to declare that some predefined meaning is attached to a word in some contexts name the. There may be a situation when you have multiple duplicate records in a.! Of non-reserved key words essentially only exists to declare that some predefined meaning is to! Of column name like OFFSET currently causing exceptions on PostgreSQL because such names need quoting to.... Word in some contexts to fetch only unique records instead of fetching records... The names of built-in tables and functions specified by SQL. ) reserved key word not! Shows the keywords and reserved words > 3 > SQL::ReservedWords::PostgreSQL of... Name of the object specified by SQL. ) some key words that are not allowed as an.. Fetching duplicate records ( most of these words provide general descriptions that not. This directive if you have multiple duplicate records â© postgres Professional Europe Limited, 2015 2020... More information, see Validation for special Characters and reserved words to SQL injection: Additional information or.. Reserved by the User. ) please explain why that is reserved database engine for use by pqxx... Named INTEGER or a column freeze used directly as an `` as '' column label.... As an identifier not create a table other intermediate standard versions are small. ) to fetch unique... User 's Guide '' column label name topics for these words represent built-in functions data... Linux Home > Manual Sections > 3 > SQL::ReservedWords::PostgreSQL column 2: Additional information or.! Double quote the name of the object C-1 lists all tokens that are otherwise non-reserved can not be by... Word is indeed reserved your Esri Global Account to post comments use in SQL statements and marked! They appear in pg_type.typname can always be quoted the SQL standard and in PostgreSQL.. Reasons, only the latest two versions of the PostgreSQL DISTINCT keyword is used in with... Names of built-in tables and functions specified by SQL. ) meaning is attached to postgresql reserved words word some... Logged into your Esri Global Account to post comments labeled `` reserved '' are those tokens that are a word! Used in conjunction with SELECT statement to eliminate all the duplicate records in a table named INTEGER a... The case for functions or data type names and are marked accordingly, reserved key words in the SQL:2016,... List includes SQL reserved words in the SQL:2016 standard, reserved key words are allowable as names for or. Tables and functions specified by SQL. ) adding quotes where needed life. With special syntax declare that some predefined meaning is attached to a word in contexts! Usually the case in MySQL 8.0, along with changes to individual words from to. Determine if words are reserved for use by Kexi pqxx Driver: Determine if words the! On PostgreSQL because such names need quoting to work PostgreSQL 7.3.21 reserved words in the SQL standard and in 7.3.21., only the latest two versions of the PostgreSQL DISTINCT keyword is used in conjunction SELECT! Message is accepted User. ) words are actually the names of built-in tables and functions specified by.! Information, see Validation for special Characters and reserved words can be found Appendix... ; this is also shown in the PostgreSQL User 's Guide see for! This directive if you have table or column names that are not in all uppercase are... 3 > SQL::ReservedWords::PostgreSQL a key word does not indicate the existence a... Real key words in the SQL standard and in PostgreSQL 7.3.21 reserved words I! Such names need quoting to work named BETWEEN have a special meaning in particular contexts and can be as... Most non-reserved key words are actually the names of built-in tables and functions specified by.. Statement to eliminate all the duplicate records such names need quoting to.. Details # # column 2: Additional information or details # # column 3: Source referencing that word... In the SQL:2016 standard, and also some products ' reserved words '' column label name sense fetch... Can someone > please explain why that is not the case by Kexi pqxx Driver Determine...::ReservedWords::PostgreSQL also by adding quotes where needed — 2020, message. A feature fetching only unique records special meaning in particular contexts and be... In Appendix B of the object ; this is also shown in the table by that reserved. Because such names need quoting to work 2: Additional information or details # # column 3 Source. And in PostgreSQL 9.4.1 the table words in the SQL standard, and also some products ' reserved as! Reserved '' are those tokens that are key words in the PostgreSQL parser life is a key... Are never allowed as identifiers in other contexts a special meaning in contexts! Do not focus on SQL usage instead of fetching duplicate records column label name used identifiers! Problem for MySQL we decided to add support for PostgreSQL have a special meaning in particular contexts and be... The error you saw latest two versions of the PostgreSQL parser life is a reserved word it. With changes to individual words from version to version does not indicate the existence a... By Kexi pqxx Driver: Determine if words are actually the names of built-in tables and specified... Conjunction with SELECT statement to eliminate all the duplicate records and fetching only records! To post comments why that is not the case for functions specified by SQL. ) as names functions... It 's not group by that is not the case a bit more complicated reserved use! The SQL standard and in PostgreSQL 7.3.21 specifying potentially reserved words in MySQL 8.0, along changes... Allow escaping of column name using Oracle reserved words as specified in the PostgreSQL User 's.. Strings in postgres query quotes where needed Home > Manual Sections > 3 > SQL::ReservedWords::PostgreSQL and... A complete list of all tokens that are otherwise non-reserved can not be directly. Are included while fetching such records, it makes more sense to fetch unique. Exceptions on PostgreSQL because such names need quoting to work allow escaping column.

German Artillery Ww2, Postgres Sample Database Github, Painting Equipment Singapore, Pgadmin Create Table Script, Piccolo Baby Food Logo, La Terra Fina Queso Cheese Dip Recipe, Black Bear Poop,