Re: convert mdb files to pg? - Mailing list pgsql-general

From Stephen Frost
Subject Re: convert mdb files to pg?
Date
Msg-id 20050127232613.GY10437@ns.snowman.net
Whole thread Raw
In response to Re: convert mdb files to pg?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
* Joshua D. Drake (jd@commandprompt.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

Attachment

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: changing sort_mem on the fly?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: changing sort_mem on the fly?