Re: From SQLite to Postgres

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