Re: Copying data from one table of one database to other table f other database

Поиск
Список
Период
Сортировка
От Sean Davis
Тема Re: Copying data from one table of one database to other table f other database
Дата
Msg-id 264855a00904270347t7d678c5brdd0c335f0a6ab980@mail.gmail.com
обсуждение исходный текст
Ответ на Copying data from one table of one database to other table f other database  ("Preetam Palwe" <preetamp@aftek.com>)
Список pgsql-novice
Дерево обсуждения


On Mon, Apr 27, 2009 at 6:30 AM, Preetam Palwe <preetamp@aftek.com> wrote:

Hello all

                I want to copy the data from one table to other table. These tables reside in two different databases.

I am thinking of using following query

 

insert into table2 (select * from table1)

 

but the problem is how can I specify the database name?


You'll need to look at the dblink contrib module.  Postgres does not include the ability to use cross-database queries out-of-the-box.  The better way of doing what you are talking about is to use separate schemas within the same database.

Sean
 

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Preetam Palwe"
Дата:
Сообщение: Copying data from one table of one database to other table f other database
Следующее
От: Bryan Emrys
Дата:
Сообщение: Question on collapsing a sparse matrix