Postgres Pro
Downloads
Home   >   mailing lists

Re: Using the database to validate data - Mailing list pgsql-general

From Jon Lapham
Subject Re: Using the database to validate data
Date
Msg-id 55B13AD8.5070301@jandr.org
Whole thread Raw
In response to Re: Using the database to validate data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
On 07/23/2015 03:02 PM, Adrian Klaver wrote:
> http://pgloader.io/

Ok, thanks, I'll look into pgloader's data validation abilities.

However, my naive understanding of pgloader is that it is used to
quickly load data into a database, which is not what I am looking to do.
I want to validate data integrity *before* putting it into the database.
If there is a problem with any part of the data, I don't want any of it
in the database.

-Jon

--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
  Jon Lapham  <lapham@jandr.org>                Rio de Janeiro, Brasil
  Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: pgbench tps drop from 5000 to 37 going from localhost to a server 13ms away
Next
From: JPLapham
Date:
Subject: Re: Using the database to validate data