Re: How to Create a table in another database

On 12.11.2015 19:56, Guillaume Lelarge wrote:
> Hey,
>
> 2015-11-12 11:26 GMT+01:00 Archana K N <archanakknn(at)gmail(dot)com
> <mailto: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..." ?
>
>
to me it looks like Archana is mixing PHP and SQL. "more details" certainly is the
right reaction here.

/Str.