Re: query a table from one database to another

I am getting the error:

------------------------------------------------------------------------
LINE 1: select dblink_connect('dbname=postgres');
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
------------------------------------------------------------------------

Please tell me why? I am using Postgresql 8.3

On Wed, Jan 27, 2010 at 10:45 PM, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:

> On Wed, Jan 27, 2010 at 02:52:58PM +0600, AI Rumman wrote:
> > I am using Postgresql 8.3
> >
> > I have two databases:
> > db1
> > db2
> >
> > db1 holds a table tab1.
> >
> > Is it possible to get the value of the above tab1 in db2 database?
> >
> > Regards
>
> You'll need something like the dblink contrib module to get one database to
> talk to another.
>
> --
> Joshua Tolley / eggyknap
> End Point Corporation
> http://www.endpoint.com
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAktgbbEACgkQRiRfCGf1UMOaJgCghp24Dl0A/6guXGq9i1lFvZXO
> 5LUAnR6QcObCEdttp9/dh1hhdopZzI7e
> =kq0K
> -----END PGP SIGNATURE-----
>
>