Re: insert from other database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: Esneiker <eenriquez(at)cav(dot)desoft(dot)cu>, pgsql-general(at)postgresql(dot)org
Subject: Re: insert from other database
Date: 2009-06-04 15:03:38
Message-ID: 15038.1244127818@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman(at)gmail(dot)com> writes:
> On Thu, Jun 4, 2009 at 3:44 PM, Esneiker <eenriquez(at)cav(dot)desoft(dot)cu> wrote:
>> How can I insert data in a database from other database?
>> Like this: insert into name_table select from database.table?

> you can't with postgresql directly.
> You can use dbconnect module from contrib to do stuff like that.

If you expect to do this a lot, you should rethink whether you ought
to be dividing your tables up into different databases. Different
schemas in one database might be the right way instead. (What
mysql calls "databases" are a lot closer to our "schemas".)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2009-06-04 15:05:20 Re: Accessing pg_controldata information from SQL
Previous Message Bill Moran 2009-06-04 14:58:28 Re: Re: High I/O writes activity on disks causing images on browser to lag and not load