Re: SQLite to Postgres, II

On Wed, 16 Feb 2011, Michael Ewan wrote:

> Since it already has all the INSERT statements, you only need to run it as an
> input file:
>
> psql -U username -d database -f foo.sql

I have a problem that's probably a datatype mis-match and I'm just not
seeing it. The error reported is:

[rshepard(at)salmo ~]$ psql -U rshepard -d nevada -f fillwells.sql
psql:fillwells.sql:1: ERROR: syntax error at or near "N"
LINE 1: ...1|25||0||-710179200000|D|N|N||H|C|32031|087|N19|19N|E20|20E|...
^
and it's the same for every row in the input file. That's the 16th column.
Here are the first 18 columns of the table definition:

CREATE TABLE welllog (
sequence_no INTEGER,
well_log INTEGER,
app TEXT,
notice_of_intent INTEGER,
waiver_no TEXT,
date_log_rcvd DATE,
date_log_rcvd_acc TEXT,
site_type TEXT,
work_type TEXT,
work_type_rmks TEXT,
proposed_use TEXT,
drilling_method TEXT,
sc TEXT,
ha TEXT,
twn TEXT,
legal_twn TEXT,
rng TEXT,
legal_rng TEXT,

The problem is with the 'legal_twn' column but I'm just not seeing it. I'm
sure that for a fresh pair of eyeballs it will be immediately obvious.
Please point out what I'm missing.

TIA,

Rich