On Wed, Feb 16, 2011 at 5:49 PM, Rich Shepard <rshepard(at)appl-ecosys(dot)com>wrote:
> 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|...
> ^
>
can you post the whole row from the input file?
-wes