orafce
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Module:
Categories:
Overview
PGDG 1st Party Extension: orafce
: Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Information
- Extension ID: 9000
- Extension Name:
orafce
- Package Name:
orafce
- Category:
SIM
- License: BSD 0
- Website: https://github.com/orafce/orafce
- Language: C
- Extra Tags:
oracle
- Comment: N/A
Metadata
- Latest Version: 4.14
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
orafce_$v*
- RPM Ver :
4.14
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-orafce
- DEB Ver :
4.14
- DEB Deps: N/A
Packages
OS | Arch | PG17 | PG16 | PG15 | PG14 | PG13 |
---|---|---|---|---|---|---|
el8 |
x86_64 |
orafce_17 PGDG 4.14.0 |
orafce_16 PGDG 4.9.4 |
orafce_15 PGDG 4.9.4 |
orafce_14 PGDG 4.9.4 |
orafce_13 PGDG 4.9.4 |
el8 |
aarch64 |
orafce_17 PGDG 4.14.0 |
orafce_16 PGDG 4.9.4 |
orafce_15 PGDG 4.9.4 |
orafce_14 PGDG 4.9.4 |
orafce_13 PGDG 4.9.4 |
el9 |
x86_64 |
orafce_17 PGDG 4.14.0 |
orafce_16 PGDG 4.9.4 |
orafce_15 PGDG 4.9.4 |
orafce_14 PGDG 4.9.4 |
orafce_13 PGDG 4.9.4 |
el9 |
aarch64 |
orafce_17 PGDG 4.14.0 |
orafce_16 PGDG 4.9.4 |
orafce_15 PGDG 4.9.4 |
orafce_14 PGDG 4.9.4 |
orafce_13 PGDG 4.9.4 |
d12 |
x86_64 |
postgresql-17-orafce PGDG 4.14.1 |
postgresql-16-orafce PGDG 4.14.1 |
postgresql-15-orafce PGDG 4.14.1 |
postgresql-14-orafce PGDG 4.14.1 |
postgresql-13-orafce PGDG 4.14.1 |
d12 |
aarch64 |
postgresql-17-orafce PGDG 4.14.1 |
postgresql-16-orafce PGDG 4.14.1 |
postgresql-15-orafce PGDG 4.14.1 |
postgresql-14-orafce PGDG 4.14.1 |
postgresql-13-orafce PGDG 4.14.1 |
u22 |
x86_64 |
postgresql-17-orafce PGDG 4.14.1 |
postgresql-16-orafce PGDG 4.14.1 |
postgresql-15-orafce PGDG 4.14.1 |
postgresql-14-orafce PGDG 4.14.1 |
postgresql-13-orafce PGDG 4.14.1 |
u22 |
aarch64 |
postgresql-17-orafce PGDG 4.14.1 |
postgresql-16-orafce PGDG 4.14.1 |
postgresql-15-orafce PGDG 4.14.1 |
postgresql-14-orafce PGDG 4.14.1 |
postgresql-13-orafce PGDG 4.14.1 |
u24 |
x86_64 |
postgresql-17-orafce PGDG 4.14.1 |
postgresql-16-orafce PGDG 4.14.1 |
postgresql-15-orafce PGDG 4.14.1 |
postgresql-14-orafce PGDG 4.14.1 |
postgresql-13-orafce PGDG 4.14.1 |
u24 |
aarch64 |
postgresql-17-orafce PGDG 4.14.1 |
postgresql-16-orafce PGDG 4.14.1 |
postgresql-15-orafce PGDG 4.14.1 |
postgresql-14-orafce PGDG 4.14.1 |
postgresql-13-orafce PGDG 4.14.1 |
Installation
Install orafce
via the pig
CLI tool:
pig ext install orafce
Install orafce
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["orafce"]}' # -l <cls>
Install orafce
RPM from YUM repo directly:
dnf install orafce_17*;
dnf install orafce_16*;
dnf install orafce_15*;
dnf install orafce_14*;
dnf install orafce_13*;
Install orafce
DEB from APT repo directly:
apt install postgresql-17-orafce;
apt install postgresql-16-orafce;
apt install postgresql-15-orafce;
apt install postgresql-14-orafce;
apt install postgresql-13-orafce;
Enable orafce
extension on PostgreSQL cluster:
CREATE EXTENSION orafce;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.