Oracle 19 foreign data wrapper in PostgreSQL setup

create.fdw.sql

--- this GIST is available under the conditions of
--- https://creativecommons.org/licenses/by/4.0/

CREATE EXTENSION oracle_fdw;

drop server orcl19;
CREATE SERVER orcl19 FOREIGN DATA WRAPPER oracle_fdw
          OPTIONS (dbserver '//localhost:1521/ORCL19');

GRANT USAGE ON FOREIGN SERVER orcl19 TO postgres;

drop user mapping for postgres server orcl19;
CREATE USER MAPPING FOR postgres SERVER orcl19 
          OPTIONS (user 'username', password 'password');          

drop foreign table oradb;
drop foreign table oratab;

--- demo from BGOUG19 showcase

create foreign table vintage ( 
	id integer options (key 'true') not null,
	name character varying(32),
	dbname character varying(32)
) server orcl19 options (schema 'C##BGOUG', table 'VINTAGE');

select * from vintage;