Re: convert mdb files to pg?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Rick Schumeyer <rschumeyer(at)ieee(dot)org>, "'PgSql General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: convert mdb files to pg?
Date: 2005-01-27 23:26:13
Message-ID: 20050127232613.GY10437@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Joshua D. Drake (jd(at)commandprompt(dot)com) wrote:
> Rick Schumeyer wrote:
> >Is there a way to import mdb files from Access into pg?
> >
> I would use ODBC to create linked tables from Pg and copy from the unlinked
> mdb tables.

I've tried doing thing and discovered that for large tables it can be
quite slow... (3 hours for a couple million rows), don't suppose you
have some way to speed it up?

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-01-28 00:23:21 Re: changing sort_mem on the fly?
Previous Message Lonni J Friedman 2005-01-27 22:57:22 changing sort_mem on the fly?