session中生效

SET enable_oracle_compatible to ON;

配置某个库默认生效

alter database teledb set enable_oracle_compatible to on;

配置某个用户默认生效

alter role admin set enable_oracle_compatible to on;