Re: [GENERAL] copy data between database

2005-10-10 Thread Scott Marlowe
On Mon, 2005-10-10 at 13:53, Qingqing Zhou wrote: > "Scott Marlowe" <[EMAIL PROTECTED]> wrote > > > > Under no circumstances should you do this with a database that has any > > data in it that you value. pg_dump / pg_restore / psql are the > > preferred way of doing this. > > > > Oh yeah, sorry f

Re: [GENERAL] copy data between database

2005-10-10 Thread Qingqing Zhou
"Scott Marlowe" <[EMAIL PROTECTED]> wrote > > Under no circumstances should you do this with a database that has any > data in it that you value. pg_dump / pg_restore / psql are the > preferred way of doing this. > Oh yeah, sorry for the miss leading information. My method is dangerous and can

Re: [GENERAL] copy data between database

2005-10-10 Thread Scott Marlowe
On Fri, 2005-10-07 at 21:34, Qingqing Zhou wrote: > <[EMAIL PROTECTED]> wrote > > Hi, I have a table A in both database d1 and d2. I would like to copy > > data in A in d1 to A in d2. How can I do it? I do not want to copy all > > data, just some part of A, > > > > > > Here is a way if you feel wa

Re: [GENERAL] copy data between database

2005-10-07 Thread Qingqing Zhou
<[EMAIL PROTECTED]> wrote > Hi, I have a table A in both database d1 and d2. I would like to copy > data in A in d1 to A in d2. How can I do it? I do not want to copy all > data, just some part of A, > > Here is a way if you feel want to try. The basic idea is that create a table (say OS file na

Re: [GENERAL] copy data between database

2005-10-07 Thread Hannes Dorbath
Never used it, but look at contrib/dblink and better use different schemas instead of different databases in future -- if you want to exchange data. On 07.10.2005 03:55, [EMAIL PROTECTED] wrote: Hi, I have a table A in both database d1 and d2. I would like to copy data in A in d1 to A in d2. H