pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Copy to another server
2+ messages / 2 participants
[nested] [flat]

* Copy to another server
@ 2006-09-29 13:41 Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
  2006-09-30 02:56 ` Re: Copy to another server Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 2+ messages in thread

From: Sistemas C.M.P. @ 2006-09-29 13:41 UTC (permalink / raw)
  To: pgsql-admin

I need to select a group of records in one table, and then copy this group to similar table in another database and another server.
How can I do this? 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Copy to another server
  2006-09-29 13:41 Copy to another server Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
@ 2006-09-30 02:56 ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2006-09-30 02:56 UTC (permalink / raw)
  To: Sistemas C.M.P. <sistemascmp@redynet4.com.ar>; +Cc: pgsql-admin

On Fri, Sep 29, 2006 at 10:41:33 -0300,
  "Sistemas C.M.P." <sistemascmp@redynet4.com.ar> wrote:
> I need to select a group of records in one table, and then copy this group to similar table in another database and another server.
> How can I do this?

Long at using the dblink contrib module. If that isn't available
to you, then you can select the data into a temp table and use copy
to produce csv output (in 8.2 you will be able to skip the temp table
step) and then import the csv file into the other database.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-09-30 02:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-29 13:41 Copy to another server Sistemas C.M.P. <sistemascmp@redynet4.com.ar>
2006-09-30 02:56 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox