I created a postgres function in db1, from which I need to create a table in another database say db2. I tried to use 'dblink' but it is giving the error:-
ERROR: function dblink_connect(unknown, unknown) does not exist
LINE 1: select dblink_connect('dbname=mydb port=5432 host=localhost ...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Have been stuck on this for 2 days. Dont know what to do.
I am using Windows 7 OS(32-bit) and due to certain security purpose am using Postgres 9.0(cant update it to newer version).
Please help me.
Have you installed dblink on the db1 database? If yes, can you give us the complete query that begins with "select dblink_connect..." ?