| From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
|---|---|
| To: | "Robert Rak" <robertrak81(at)tlen(dot)pl> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: select from different database |
| Date: | 2007-01-08 12:07:14 |
| Message-ID: | bf54be870701080407n3f3e429ha8ba38134d758493@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
You can use the 'dblink' contrib module for that purpose...
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Robert Rak <robertrak81(at)tlen(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guido Barosio | 2007-01-08 12:13:46 | Re: select from different database |
| Previous Message | Robert Rak | 2007-01-08 12:01:43 | select from different database |