Re: How to convert?

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Ron St-Pierre <rstpierre(at)syscor(dot)com>, Yves <yvenault(at)yahoo(dot)ca>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to convert?
Date: 2004-07-16 22:25:58
Message-ID: 20040716222558.9218.qmail@web20806.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- Ron St-Pierre <rstpierre(at)syscor(dot)com> wrote:
> Yves wrote:
>
> >Hello again,
> >
> >I was wondering if anyone has every come across a
> >program (or a way to do this) that would convert an
> >access database into postgres.
> >
> pgAdmin has a plugin which does this. I've used it
> with an earlier
> version of pgAdmin about 2 years ago with good
> results.
>

I've had good results with it too. But the plugin
only exists for pgAdminII, not for pgAdminIII, which
is the newest version. But I think you can still find
pgAdminII by searching for it.
> >
> >I have this small Access db that I would very much
> >like that convert into postgres...
> >
> >I have this small program that converts into an sql
> >dump file specifically for MySQL, I've been told
> that
> >the autoincrement directions in the file would not
> be
> >compatible with Postgres. Is that correct?
> >
> >Any ideas?
> >
> >Thanks again,
> >
> >Yves Arsenault
> >
>
>______________________________________________________________________
>
> >Post your free ad now! http://personals.yahoo.ca
> >
> >---------------------------(end of
> broadcast)---------------------------
> >TIP 9: the planner will ignore your desire to
> choose an index scan if your
> > joining column's datatypes do not match
> >
> >
> >
> >
> Ron St-Pierre
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>


__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jeff Eckermann 2004-07-16 22:45:16 Re: getting info out of a dump from postgresql
Previous Message Yves 2004-07-16 22:19:07 Re: [Fwd: Re: How to convert?]