[SQL] DB link from postgres to Oracle; how to query Dbname.tablename?

Hi all, greetings!   Using Oracle Heterogeneous Services (Oracle HS) I have configured/created a DB link from Postgres 9.3 database into Oracle 11gR3 database (with postgres DB user credentials).  SQL>  create public database link pg_link connect to "postgres" identified by "blahblah" using 'pos

[SQL] Encrypting PGBouncer to Postgres DB connections

Hi all,   Can someone please point me to detailed documentation on how to secure/encrypt connections between PGBouncer and Postgresql database (version 8.4.3)?    Thanks in advance!   Bhanu M. Gandikota Cell: (415) 420-7740