Re: SQLite to Postgres, II

On Wed, 16 Feb 2011, wes wrote:

> can you post the whole row from the input file?

Wes,

I should have done that before. Here's my small test file:

INSERT INTO welllog VALUES(73261|25||0||-710179200000|D|N|N||H|C|32031|087|N19|19N|E20|20E|04||||MD|39.5424995422363|119.741104125977|NV003|M|SPARKS AIR PARK|||||||-754588800000|D||NULL|125|NULL||125|8.0|0|2|31|1|2.0|NULL|NULL|NULL|NULL||G|G|||3|MEL MEYER|RT 1 BOX 10 RENO NV|NULL|3|NV003|CLIDDELL|1057906800000|HWOOD|1058770800000|F|-755020800000|NULL|NULL|264442.244883072|4380360.93941406);
INSERT INTO welllog VALUES(69300|26||0||NULL||N|N||A|C|32031|087|N19|19N|E19|19E|11||||MD|39.5277786254883|119.815277099609|NV003|M|SAVAGE & SON|100 BLOCK NORTH VIRGINIA ROAD|| ||||-764179200000|D| |NULL|32|NULL| |32|6.0|1|NULL|NULL|1|NULL|NULL|NULL|NULL|NULL| |G|G|DRY HOLE||3 |MEL MEYER||NULL|NULL|NV003|JSWINGHOLM|1047024000000||NULL|F|-765129600000|NULL|NULL|258016.598278775|4378923.63873157);
INSERT INTO welllog VALUES(70821|28||0||NULL||N|N||C|C|32031|087|N19|19N|E19|19E|24||||MD|39.4988899230957|119.796112060547|NV003|M|HILL, A AND SON|S VIRGINIA ST RENO||||||-763142400000|D||NULL|34|NULL||34|6.0|0|12|32|1|7.0|NULL|NULL|NULL|NULL| |G|G|||3 |MEL MEYER|RT 1 BOX 10 RENO NV|NULL|NULL|NV003|CLIDDELL |1052463600000|MDILLON |1053068400000|F|-763228800000|NULL|NULL|259564.643538006|4375665.45627634);
INSERT INTO welllog VALUES(70413|29||0||NULL| |N|N||H|C|32031|087 |N19 |19N |E19 |19E |23| | | |MD |39.4986114501953|119.815002441406|NV003|M|LINABARY, ESTER|LAKESIDE DR RENO|| ||||-756748800000|D| |NULL|89|NULL| |89|6.0|0|17|87|1|11.0|NULL|NULL|NULL|NULL|U|G|G|||3 |MEL MEYER|RT 1 BOX 10 RENONV|NULL|3|NV003|CLIDDELL|1051513200000|MDILLON|1053327600000|F|-757180800000|NULL|NULL|257939.187782148|4375685.25824656);
INSERT INTO welllog VALUES(82949|30||0||-707587200000|D|N|N||H|H|32510|104 |N15 |15N |E20 |20E |08|B |NW | |MD |39.185001373291|119.765274047852|NV003|M|BARRINGTON, EDWARD|CARSON CITY|| ||||-722620800000|D| |NULL|63|NULL| |63|5.0|1|57|62|1|1.0|NULL|10.0|NULL|NULL|J|G|G|WELL ADD=1/4 MI N OF CARSON ON RENO HWY||6|JESSE J HARRISON|CARSON|NULL|NULL|NV003|SCOX|1085554800000|MDILLON |1086678000000|F|-733507200000|NULL|NULL|261149.505235839|4340741.51744913);
INSERT INTO welllog VALUES(82946|31||0||-708278400000|D|N|N||H|H|32510|104 |N15 |15N |E20 |20E |08|C |SW | |MD |39.1758346557617|119.763053894043|NV003|M|ECHART, LEON|CARSON|| ||||-708710400000|D|Y|NULL|70|NULL| |70|4.0|0|60|70|1|NULL|NULL|NULL|NULL|NULL| |G|G|WELL ADD=AT LONE MT GARAGE ON N CARSON||6|JESSE J HARRISON|CARSON|NULL|6|NV003|SCOX|1085554800000|MDILLON|1086678000000|F|-709056000000|NULL|NULL|261310.456177631|4339718.17338806);

The lines will wrap.

Rich