PG（HGDB）里创建表时不校验列名关键字_postgresql 设置sql中不检查关键字-优快云博客

本文探讨了在PG（HGDB）数据库中创建表时列名关键字不受限制的现象，与Oracle数据库进行对比。在Oracle中，使用特定关键字作为列名可能会导致错误，但在PG（HGDB）中则允许，揭示了两者在数据库设计上的差异。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle数据库现象：

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> create table a(table int);
create table a(table int)
*
ERROR at line 1:
ORA-00904: : invalid identifier

SQL> create table a(column int);
create table a(column int)
*
ERROR at line 1:
ORA-00904: : invalid identifier

Oracle中使用关键字作为列名时，字段需加双引号：
SQL> create table a("column" int);
Table created.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

HGDB现象：

highgo=# select version();
version
------------------------------------
HighGo Database 3.1.4 Linux 64-bit
(1 row)
highgo=# create table a(relation int);
CREATE TABLE
highgo=# create table c(tuple int);
CREATE TABLE
highgo=# \d a
Table "public.a"
Column | Type | Modifiers
----------+---------+-----------
relation | integer |

highgo=# \d b
Table "public.b"
Column | Type | Modifiers
----------+---------+-----------
relation | integer |