Re: How to Create a table in another database

Hey,

2015-11-12 11:26 GMT+01:00 Archana K N <archanakknn(at)gmail(dot)com>:

> Hello,
>
> 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..." ?

Thanks.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com