Postgresql 9.2 Install Dblink
Postgrseql 9.1 provides for a new command. You should use it to install modules..
I am used to Oracle and to create a dblink in my schema and then access to a remote database like this: mytable@myremotedb, is there anyway do to the same with PostgreSQL? Right now I am using dblink like this: SELECT logindate FROM dblink('host=dev.toto.com user=toto password=isok dbname=totofamily', 'SELECT logindate FROM loginlog'); When I execute this command I get the following error: HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Postgresql 9.2 Jdbc Driver
Nov 7, 2013 - I attempted to install Spacewalk 2.0 on a server using Postgresql 9.2.5. /usr/share/pgsql/contrib/dblink.sql: No such file or directory > > There. Dblink executes a query (usually a SELECT, but it can be any SQL statement that returns rows) in a remote database. When two text arguments are given, the first one is first looked up as a persistent connection's name; if found, the.