Postgres Pro
Downloads
Home   >   mailing lists

Re: select from different database - Mailing list pgsql-novice

From Shoaib Mir
Subject Re: select from different database
Date
Msg-id bf54be870701080407n3f3e429ha8ba38134d758493@mail.gmail.com
Whole thread Raw
In response to select from different database  (Robert Rak <robertrak81@tlen.pl>)
List pgsql-novice
Tree view
You can use the 'dblink' contrib module for that purpose...

-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/8/07, Robert Rak <robertrak81@tlen.pl> wrote:
Hi all :)

Is it possible to fetch data from another database than the current?

I have stored procedure in DB_1 and I would like do INSERT to table in
DB_2. Is it possible?
If yes, ho to do it?

Thanks
Robert

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

pgsql-novice by date:

Previous
From: Robert Rak
Date:
Subject: select from different database
Next
From: "Guido Barosio"
Date:
Subject: Re: select from different database