Skip site navigation (1) Skip section navigation (2)

Re: SQLite to Postgres, II

From: wes <pdxpug(at)the-wes(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: SQLite to Postgres, II
Date: 2011-02-17 04:48:58
Message-ID: AANLkTikFLobUP59gwQJohB8oph94xtaV0E70=OYRX5DF@mail.gmail.com (view raw or flat)
Thread:
Lists: pdxpug
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

In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-17 13:54:41
Subject: Re: SQLite to Postgres, II
Previous:From: Rich ShepardDate: 2011-02-17 01:49:08
Subject: Re: SQLite to Postgres, II

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group