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
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 |