=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@xxxxxxxxx> writes: > On Thu, Jun 4, 2009 at 3:44 PM, Esneiker <eenriquez@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
