Re: Copying data from a table to another database - Mailing list pgsql-general

From Pedro Doria Meunier
Subject Re: Copying data from a table to another database
Date
Msg-id 1212069657.11535.16.camel@213-190-214-90-cmts01.netmadeira.com
Whole thread Raw
In response to Copying data from a table to another database  (Pedro Doria Meunier <pdoria@netmadeira.com>)
List pgsql-general
Dears
Craig, Roberts, Reece and Shane

Thank you very much for your thoughts. They're helpful! ;-)
I've chosen the dump approach to another table in the migration server
and then INSERTing the different recs with a WHERE clause for every
non-existing timestamp for a deviceID.

As far as the pkey was concerned (entry_nbr) it didn't cause me any
problems as what's important were the timestamps in the relevant column.
Again thanks!

Best regards,
--
Pedro Doria Meunier <pdoria@netmadeira.com>


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Howto implement sxntax and semantic complie time chock for
Next
From: Justin
Date:
Subject: Re: New MS patent: sounds like PG db rules