Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group