[PLUG] Removing Duplicate Rows from SQL Dump

Rich Shepard rshepard at appl-ecosys.com
Tue Aug 16 15:20:26 UTC 2011


On Tue, 16 Aug 2011, Roderick A. Anderson wrote:

> Can we see another snapshot of the data? And (did I miss it?) which three
> columns.

Rod,

   Yep, and yep.

Data:

\N	CVS	1994-01-20	Conductance, Specific	460	uS/cm	t \N	\N	\N
\N	CVS	1994-01-20	Conductance, Specific	522	uS/cm	t \N	\N	\N

   (Fred: I think that pg_dump does use tabs as column separators, and there
are spaces within a column as the above demonstrates. These data were
extracted from Excel spreadsheets.)

   The three columns are the second, third, and fourth, named loc_name,
sample_date, and param.

   The current client staff can't figure out either how there could be two
different values for specific conductance at the same location on the same
date when both were supposedly checked for quality (the 't' in the seventh
column).

Rich




More information about the PLUG mailing list