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

Re: From SQLite to Postgres

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: From SQLite to Postgres
Date: 2011-02-16 18:18:25
Message-ID: 1297880305.17744.152.camel@jd-desktop (view raw or flat)
Thread:
Lists: pdxpug
On Wed, 2011-02-16 at 10:03 -0800, Rich Shepard wrote:
> I've not done this before so I don't know where the gotcha's might be.
> 
>    I downloaded a rather huge well log file (that is, a record of all wells
> dug after being granted a water right) for another state. Naturally, they
> have it as an Access table (.mdb). I used the tool, mdb-sqlite to convert it
> to a sqlite3 database, then dumped it from sqlite as a .sql file.

If you have access to Access, that is the best bet. You would just open
the access database and link tables from postgresql and then you can
literally drag and drop.

If you can't do that I would use Perl or Python to connect to the sqlite
database and move the data directly across to PostgreSQL. 

JD

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


In response to

Responses

pdxpug by date

Next:From: Michael EwanDate: 2011-02-16 18:29:22
Subject: Re: From SQLite to Postgres
Previous:From: Brent DombrowskiDate: 2011-02-16 18:11:37
Subject: Re: From SQLite to Postgres

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