PostgreSQL的保留字列表

2 年 ago

雅, 悟

1 minute

首先

在尝试使用JPA在PostgreSQL中创建表时，由于语法错误导致无法创建表，我陷入了困境，因此汇总了预订后的列表。

请使用⌘+F或ctrl+F进行搜索。

预约后清单

キーワードABSALLALLOCATEANALYSEANALYZEANDANYAREARRAYARRAY_AGGARRAY_MAX_CARDINALITYASASCASENSITIVEASYMMETRICATOMICAUTHORIZATIONAVGBEGIN_FRAMEBEGIN_PARTITIONBINARYBIT_LENGTHBLOBBOTHCARDINALITYCASECASTCEILCEILINGCHARACTER_LENGTHCHAR_LENGTHCHECKCLOBCOLLATECOLLATIONCOLLECTCOLUMNCONCURRENTLYCONDITIONCONNECTCONSTRAINTCONTAINSCONVERTCORRCORRESPONDINGCOUNTCOVAR_POPCOVAR_SAMPCREATECROSSCUME_DISTCURRENT_CATALOGCURRENT_DATECURRENT_DEFAULT_TRANSFORM_GROUPCURRENT_PATHCURRENT_ROLECURRENT_ROWCURRENT_SCHEMACURRENT_TIMECURRENT_TIMESTAMPCURRENT_TRANSFORM_GROUP_FOR_TYPECURRENT_USERDATALINKDATEDEFAULTDEFERRABLEDENSE_RANKDEREFDESCDESCRIBEDETERMINISTICDISCONNECTDISTINCTDLNEWCOPYDLPREVIOUSCOPYDLURLCOMPLETEDLURLCOMPLETEONLYDLURLCOMPLETEWRITEDLURLPATHDLURLPATHONLYDLURLPATHWRITEDLURLSCHEMEDLURLSERVERDLVALUEDODYNAMICELEMENTELSEENDE-END_FRAMEEND_PARTITIONEQUALSEVERYEXCEPTEXCEPTIONEXECEXPFALSEFETCHFIRST_VALUEFLOORFORFOREIGNFRAME_ROWFREEFREEZEFROMFULLFUSIONGETGRANTGROUPHAVINGILIKEININDICATORINITIALLYINNERINTERSECTINTERSECTIONINTOISISNULLJOINLAGLAST_VALUELATERALLEADLEADINGLEFTLIKELIKE_REGEXLIMITLNLOCALTIMELOCALTIMESTAMPLOWERMAXMAX_CARDINALITYMEMBERMERGEMINMODMODIFIESMODULEMULTISETNATURALNCLOBNORMALIZENOTNOTNULLNTH_VALUENTILENULLOCCURRENCES_REGEXOCTET_LENGTHOFFSETONONLYOPENORORDEROUTEROVERLAPSPARAMETERPERCENTPERCENTILE_CONTPERCENTILE_DISCPERCENT_RANKPERIODPLACINGPORTIONPOSITION_REGEXPOWERPRECEDESPRIMARYRANKREADSREFERENCESREGR_AVGXREGR_AVGYREGR_COUNTREGR_INTERCEPTREGR_R2REGR_SLOPEREGR_SXXREGR_SXYREGR_SYYRESULTRETURNRETURNINGRIGHTROW_NUMBERSCOPESELECTSENSITIVESESSION_USERSIMILARSOMESPECIFICSPECIFICTYPESQLCODESQLERRORSQLEXCEPTIONSQLSTATESQLWARNINGSQRTSTATICSTDDEV_POPSTDDEV_SAMPSUBMULTISETSUBSTRING_REGEXSUCCEEDSSUMSYMMETRICSYSTEM_TIMESYSTEM_USERTABLETABLESAMPLETHENTIMEZONE_HOURTIMEZONE_MINUTETOTRAILINGTRANSLATETRANSLATE_REGEXTRANSLATIONTRIM_ARRAYTRUEUESCAPEUNIONUNIQUEUNNESTUPPERUSERUSINGVALUE_OFVARBINARYVARIADICVAR_POPVAR_SAMPVERBOSEVERSIONINGWHENWHENEVERWHEREWIDTH_BUCKETWINDOWWITHXMLAGGXMLBINARYXMLCASTXMLCOMMENTXMLDOCUMENTXMLITERATEXMLQUERYXMLTEXTXMLVALIDATE

请提供更多上下文，以便我可以为您准确翻译。

每个版本似乎都有不同的保留字。这次整理的是 PostgreSQL 12.4 的保留字。

我已经参考了以下内容。