Re: From SQLite to Postgres

gdal/ogr may help you. See supported vector formats here:
http://gdal.org/ogr/ogr_formats.html

More SQLite and postgis here:

http://postgis.refractions.net/pipermail/postgis-users/2008-April/019225.html

Bests, Eli

>>> On 2/16/2011 at 10:30 AM, in message
<alpine(dot)LNX(dot)2(dot)00(dot)1102161026320(dot)19529(at)salmo(dot)appl-ecosys(dot)com>, Rich Shepard
<rshepard(at)appl-ecosys(dot)com> wrote:
> On Wed, 16 Feb 2011, Brent Dombrowski wrote:
>
>> I've gone from Access straight to postgres in the past. I set up an ODBC
>> connection from Access to postgres and just dragged and dropped the tables
>> across. The gotcha for me was name preservation from Access required
>> quoting all the field and table names in postgres. My tables were simple,
>> your mileage may vary.
>
> Brent,
>
> Your approach requires access to Access. We don't do Microsoft. I suppose
> that I could read it into OO.o, but that seems to increase the potential for
> problems.
>
> Looking at the file in emacs (it's 88M, 110+k rows), I think I need to
> change the delimiter, drop the single quotes and the explicit NULLs, and
> clean up the empty spaces that sqlite puts in for constant length
> attributes. I'm not sure about the PRAGMA statement at the top of the file,
> or if postgres wants something different.
>
> Thanks,
>
> Rich
>