Hello,
We are trying to connect to a remote Oracle instance from PosgreSQL using FDW described @ PostgreSQL: Documentation: 9.3: postgres_fdw.
We have oracle client installed on the PostgreSQL machine. We can achieve the remote connection , but with the Oracle IP and port hardcoded.
Problem:
While creating foreign SERVER object we use
CREATE SERVER oracle_server
FOREIGN DATA WRAPPER oracle_fdw
OPTIONS (dbserver 'IP:PORT/ORACLE_DBNAME');
But we do not want to hard code IP and PORT. Is there anyway to do this?
regards
Sameer