Re: query a table from one database to another

Поиск
Список
Период
Сортировка
От AI Rumman
Тема Re: query a table from one database to another
Дата
Msg-id 2a7905441001272136n73fd32aiccadc585308e3c15@mail.gmail.com
обсуждение исходный текст
Ответ на Re: query a table from one database to another  (Joshua Tolley <eggyknap@gmail.com>)
Ответы Re: query a table from one database to another
Список pgsql-general
Дерево обсуждения
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@gmail.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-----


В списке pgsql-general по дате отправления: