How to Create a table in another database

--001a11c310be9ffee605245561c6
Content-Type: text/plain; charset=UTF-8

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.

-- 
-------------------
regards
Archana K N
--------------------

--001a11c310be9ffee605245561c6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,<div><br></div><div>=C2=A0 =C2=A0 =C2=A0I created a =
postgres function in<i><b> db1</b></i>, from which I need to create a table=
 in another database say <b style=3D"font-style:italic">db2. </b>I tried to=
 use &#39;dblink&#39; but it is giving the error:-</div><div><br></div><div=
><br></div><div>=C2=A0<font color=3D"#cc0000"> =C2=A0ERROR: =C2=A0function =
dblink_connect(unknown, unknown) does not exist</font><div><font color=3D"#=
cc0000">=C2=A0 =C2=A0LINE 1: select dblink_connect(&#39;dbname=3Dmydb port=
=3D5432 host=3Dlocalhost ...</font></div><div><font color=3D"#cc0000">=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^</font></div><div><fon=
t color=3D"#cc0000">=C2=A0 =C2=A0HINT: =C2=A0No function matches the given =
name and argument types. You might need =C2=A0 =C2=A0 =C2=A0 to add explici=
t type casts.</font></div><div><font color=3D"#cc0000"><br></font></div><di=
v><font color=3D"#000000">=C2=A0 =C2=A0 =C2=A0Have been stuck on this for 2=
 days. Dont know what to do.=C2=A0</font></div><div><font color=3D"#000000"=
>=C2=A0 =C2=A0 =C2=A0</font></div><div><font color=3D"#000000">=C2=A0 =C2=
=A0 =C2=A0I am using Windows 7 OS(32-bit) and due to certain security purpo=
se am using =C2=A0 =C2=A0 =C2=A0 =C2=A0 Postgres 9.0(cant update it to newe=
r version).=C2=A0</font></div><div><font color=3D"#000000"><br></font></div=
><div><font color=3D"#000000">=C2=A0 =C2=A0 =C2=A0 Please help me.=C2=A0</f=
ont></div><div><br></div>-- <br><div class=3D"gmail_signature">------------=
-------<br>regards<br>Archana K N<br>--------------------</div>
</div></div>

--001a11c310be9ffee605245561c6--