Thread: Converting microsoft access to postgresql

Converting microsoft access to postgresql

From
"Frederic De Leersnijder"
Date:
I'm looking for a program to convert a microsoft access mdb to postgres.

Thnx.

Frederic De Leersnijder


Re: [INTERFACES] Converting microsoft access to postgresql

From
"Brett W. McCoy"
Date:
On Wed, 24 Mar 1999, Frederic De Leersnijder wrote:

> I'm looking for a program to convert a microsoft access mdb to postgres.

pgAdmin will do the job.  It does it through the ODBC interface.  For big
databases, though, I've had better luck dumping tables to text files and
doing a bulk copy back into PostgreSQL.

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
    The Arkansas legislature passed a law that states that the Arkansas
River can rise no higher than to the Main Street bridge in Little Rock.

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------


Re: [INTERFACES] Converting microsoft access to postgresql

From
"Brett W. McCoy"
Date:
On Wed, 24 Mar 1999, Frederic De Leersnijder wrote:

> I'm looking for a program to convert a microsoft access mdb to postgres.

Oops.  Forgot the URL for pgAdmin: http://www.pgadmin.freeserve.co.uk

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Do not handicap your children by making their lives easy.
        -- Robert Heinlein

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------