From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: SQLite to Postgres, II |
Date: | 2011-02-17 01:49:08 |
Message-ID: | alpine.LNX.2.00.1102161744090.19529@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
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
From | Date | Subject | |
---|---|---|---|
Next Message | wes | 2011-02-17 04:48:58 | Re: SQLite to Postgres, II |
Previous Message | Rich Shepard | 2011-02-17 00:50:09 | Re: SQLite to Postgres, II |