Re: [SQL] Querying multiple database

2013-02-06 Thread Dev Kumkar
Hello Again, Using dblink and now am facing a fatal error while tryinf 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 connection DETAIL: FATAL: password authentication failed for user "NET

Re: [SQL] Querying multiple database

2013-02-05 Thread Dev Kumkar
Am looking for pointers related to cross-database queries? Thanks in advance! On Tue, Feb 5, 2013 at 10:42 PM, Dev Kumkar wrote: > Hello everyone, > > Please can you point me to the contrib/dblink package links. > > What am actually looking for is query multiple database located on > different

[SQL] Querying multiple database

2013-02-05 Thread Dev Kumkar
Hello everyone, Please can you point me to the contrib/dblink package links. What am actually looking for is query multiple database located on different machines. Is there any documentation for same which tells the metadata steps? Existing archive link if exists please can you point me same. Re