如果没有进行服务器级别设置,默认登录数据库后的语法为antdb
:
antdb=# show grammar ;
grammar
----------
postgres
(1 row)
此时执行Oracle语法的语句,会报错:
antdb=# select * from dual;
ERROR: relation "dual" does not exist
LINE 1: select * from dual; ^
session 级别切换到Oracle语法,再次执行Oracle语法的语句:
antdb=# set grammar to oracle;
SET
antdb=# show grammar ;
grammar
---------
oracle
(1 row)
antdb=# select * from dual;
DUMMY
-------
X
(1 row)
执行成功。