orafce

 

https://qiita.com/plusultra/items/18f09751e5e787c3af68

Rocky Linux 9
PostgreSQL17

-- 1. インストール

 

git clone https://github.com/orafce/orafce.git

cd orafce

export PATH=$PATH:/usr/pgsql-17/bin

sudo dnf install redhat-rpm-config

sudo dnf install openssl-devel

make
su
make install

exit

psql

\dx
SELECT * FROM pg_available_extensions WHERE name = 'orafce';
CREATE EXTENSION orafce;
\dx

\dn
SHOW search_path;
set search_path = "$user", public, oracle, pg_catalog;
SHOW search_path;

-- 2. 動作確認

SELECT * FROM dual;

CREATE TABLE emp(emp_id NUMERIC, first_name VARCHAR2(30), last_name NVARCHAR2(30), birth_date DATE);
\d emp

SELECT sysdate()::oracle.date, sysdate()::pg_catalog.date FROM dual;
SELECT sysdate() FROM dual;