はじめに
JPAでPostgreSQLにテーブルを作成しようとした際、syntax errorでテーブル作成ができずにハマったので
予約後一覧をまとめました。
⌘ + F または ctr + F で検索して使ってください。
予約後一覧
| キーワード |
|---|
| ABS |
| ALL |
| ALLOCATE |
| ANALYSE |
| ANALYZE |
| AND |
| ANY |
| ARE |
| ARRAY |
| ARRAY_AGG |
| ARRAY_MAX_CARDINALITY |
| AS |
| ASC |
| ASENSITIVE |
| ASYMMETRIC |
| ATOMIC |
| AUTHORIZATION |
| AVG |
| BEGIN_FRAME |
| BEGIN_PARTITION |
| BINARY |
| BIT_LENGTH |
| BLOB |
| BOTH |
| CARDINALITY |
| CASE |
| CAST |
| CEIL |
| CEILING |
| CHARACTER_LENGTH |
| CHAR_LENGTH |
| CHECK |
| CLOB |
| COLLATE |
| COLLATION |
| COLLECT |
| COLUMN |
| CONCURRENTLY |
| CONDITION |
| CONNECT |
| CONSTRAINT |
| CONTAINS |
| CONVERT |
| CORR |
| CORRESPONDING |
| COUNT |
| COVAR_POP |
| COVAR_SAMP |
| CREATE |
| CROSS |
| CUME_DIST |
| CURRENT_CATALOG |
| CURRENT_DATE |
| CURRENT_DEFAULT_TRANSFORM_GROUP |
| CURRENT_PATH |
| CURRENT_ROLE |
| CURRENT_ROW |
| CURRENT_SCHEMA |
| CURRENT_TIME |
| CURRENT_TIMESTAMP |
| CURRENT_TRANSFORM_GROUP_FOR_TYPE |
| CURRENT_USER |
| DATALINK |
| DATE |
| DEFAULT |
| DEFERRABLE |
| DENSE_RANK |
| DEREF |
| DESC |
| DESCRIBE |
| DETERMINISTIC |
| DISCONNECT |
| DISTINCT |
| DLNEWCOPY |
| DLPREVIOUSCOPY |
| DLURLCOMPLETE |
| DLURLCOMPLETEONLY |
| DLURLCOMPLETEWRITE |
| DLURLPATH |
| DLURLPATHONLY |
| DLURLPATHWRITE |
| DLURLSCHEME |
| DLURLSERVER |
| DLVALUE |
| DO |
| DYNAMIC |
| ELEMENT |
| ELSE |
| END |
| E- |
| END_FRAME |
| END_PARTITION |
| EQUALS |
| EVERY |
| EXCEPT |
| EXCEPTION |
| EXEC |
| EXP |
| FALSE |
| FETCH |
| FIRST_VALUE |
| FLOOR |
| FOR |
| FOREIGN |
| FRAME_ROW |
| FREE |
| FREEZE |
| FROM |
| FULL |
| FUSION |
| GET |
| GRANT |
| GROUP |
| HAVING |
| ILIKE |
| IN |
| INDICATOR |
| INITIALLY |
| INNER |
| INTERSECT |
| INTERSECTION |
| INTO |
| IS |
| ISNULL |
| JOIN |
| LAG |
| LAST_VALUE |
| LATERAL |
| LEAD |
| LEADING |
| LEFT |
| LIKE |
| LIKE_REGEX |
| LIMIT |
| LN |
| LOCALTIME |
| LOCALTIMESTAMP |
| LOWER |
| MAX |
| MAX_CARDINALITY |
| MEMBER |
| MERGE |
| MIN |
| MOD |
| MODIFIES |
| MODULE |
| MULTISET |
| NATURAL |
| NCLOB |
| NORMALIZE |
| NOT |
| NOTNULL |
| NTH_VALUE |
| NTILE |
| NULL |
| OCCURRENCES_REGEX |
| OCTET_LENGTH |
| OFFSET |
| ON |
| ONLY |
| OPEN |
| OR |
| ORDER |
| OUTER |
| OVERLAPS |
| PARAMETER |
| PERCENT |
| PERCENTILE_CONT |
| PERCENTILE_DISC |
| PERCENT_RANK |
| PERIOD |
| PLACING |
| PORTION |
| POSITION_REGEX |
| POWER |
| PRECEDES |
| PRIMARY |
| RANK |
| READS |
| REFERENCES |
| REGR_AVGX |
| REGR_AVGY |
| REGR_COUNT |
| REGR_INTERCEPT |
| REGR_R2 |
| REGR_SLOPE |
| REGR_SXX |
| REGR_SXY |
| REGR_SYY |
| RESULT |
| RETURN |
| RETURNING |
| RIGHT |
| ROW_NUMBER |
| SCOPE |
| SELECT |
| SENSITIVE |
| SESSION_USER |
| SIMILAR |
| SOME |
| SPECIFIC |
| SPECIFICTYPE |
| SQLCODE |
| SQLERROR |
| SQLEXCEPTION |
| SQLSTATE |
| SQLWARNING |
| SQRT |
| STATIC |
| STDDEV_POP |
| STDDEV_SAMP |
| SUBMULTISET |
| SUBSTRING_REGEX |
| SUCCEEDS |
| SUM |
| SYMMETRIC |
| SYSTEM_TIME |
| SYSTEM_USER |
| TABLE |
| TABLESAMPLE |
| THEN |
| TIMEZONE_HOUR |
| TIMEZONE_MINUTE |
| TO |
| TRAILING |
| TRANSLATE |
| TRANSLATE_REGEX |
| TRANSLATION |
| TRIM_ARRAY |
| TRUE |
| UESCAPE |
| UNION |
| UNIQUE |
| UNNEST |
| UPPER |
| USER |
| USING |
| VALUE_OF |
| VARBINARY |
| VARIADIC |
| VAR_POP |
| VAR_SAMP |
| VERBOSE |
| VERSIONING |
| WHEN |
| WHENEVER |
| WHERE |
| WIDTH_BUCKET |
| WINDOW |
| WITH |
| XMLAGG |
| XMLBINARY |
| XMLCAST |
| XMLCOMMENT |
| XMLDOCUMENT |
| XMLITERATE |
| XMLQUERY |
| XMLTEXT |
| XMLVALIDATE |
参考
バージョンごとに予約語に違いがあるみたいです。今回まとめたのはPostgreSQL１２．４の予約語です。
以下参照しました。