PostgreSQL特殊关键字
特殊关键字是指在SQL语言中有特殊用途的单词,比如ALL, ANY, ARRAY, AS, ASC, BETWEEN, BY, CASE, CAST, CREATE, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DEFAULT, EXISTS, FALSE, FOR, FROM, GROUP, HAVING, IN, INSERT, INTERSECT, INTO, IS, JOIN, LEADING, LIMIT, NOT, NULL, OFFSET, ON, OR, ORDER, SELECT, SESSION_USER, SOME, SYMMETRIC, TABLE, THEN, TO, TRAILING, TRUE, UNION, UNIQUE, USER, USING, VALUES, WHEN, WHERE, WINDOW, WITH
表字段名称如果出现这些特殊关键字,则需要通过单引号访问字段,如offset、group
select id , 'offset' , 'group' from table_name