Re: insert from other database

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