Re: How to convert? - Mailing list pgsql-novice

From Jeff Eckermann
Subject Re: How to convert?
Date
Msg-id 20040716222558.9218.qmail@web20806.mail.yahoo.com
Whole thread Raw
In response to Re: How to convert?  (Ron St-Pierre <rstpierre@syscor.com>)
List pgsql-novice
--- Ron St-Pierre <rstpierre@syscor.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/


pgsql-novice by date:

Previous
From: Yves
Date:
Subject: Re: [Fwd: Re: How to convert?]
Next
From: Jeff Eckermann
Date:
Subject: Re: getting info out of a dump from postgresql