From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: From SQLite to Postgres |
Date: | 2011-02-16 18:30:54 |
Message-ID: | alpine.LNX.2.00.1102161026320.19529@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-02-16 18:32:59 | Re: From SQLite to Postgres |
Previous Message | Michael Ewan | 2011-02-16 18:29:22 | Re: From SQLite to Postgres |