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

2013-10-02 Thread Albe Laurenz
Bhanu Murthy wrote: > 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"

[SQL] Re: [ADMIN] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Albe Laurenz
Dev Kumkar wrote: > I am using postgres 9.2 and when executing function dblink facing a fatal > error while trying to > execute dblink_connect as follows: > > SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres > password=test') > > ERROR: could not establish connecti