Re: [SQL] duplicate table in two databases

2004-08-16 Thread Richard Huxton
Fabio Ferrero wrote: I use postgres 7.2.1 (debian woody) and PHP. I've two databases (foo and bar for example) with the same table (ie. stamps). It's possible with a single query transfer the data from the stamps table in db foo to the stamps table in db bar? You might want to look in the contri

[SQL] duplicate table in two databases

2004-08-15 Thread Fabio Ferrero
I use postgres 7.2.1 (debian woody) and PHP. I've two databases (foo and bar for example) with the same table (ie. stamps). It's possible with a single query transfer the data from the stamps table in db foo to the stamps table in db bar? Or I need a row by row copy? Or maybe a dump on temp fil