Postgres Pro
Downloads
Home   >   mailing lists

Thread: [Fwd: Re: How to convert?]

[Fwd: Re: How to convert?]

From
Ron St-Pierre
Date:
I forgot to mention that you can get it from http://www.pgadmin.org
-------- Original Message --------
Subject:     Re: [NOVICE] How to convert?
Date:     Fri, 16 Jul 2004 15:11:29 -0700
From:     Ron St-Pierre <rstpierre@syscor.com>
To:     Yves <yvenault@yahoo.ca>, pgsql-novice <pgsql-novice@postgresql.org>
References:     <20040716214143.14156.qmail@web41510.mail.yahoo.com>



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 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

Re: [Fwd: Re: How to convert?]

From
Yves
Date:
Nice!

Thanks.

:-)

Yves

--- Ron St-Pierre <rstpierre@syscor.com> wrote: >
> I forgot to mention that you can get it from
> http://www.pgadmin.org
> -------- Original Message --------
> Subject:     Re: [NOVICE] How to convert?
> Date:     Fri, 16 Jul 2004 15:11:29 -0700
> From:     Ron St-Pierre <rstpierre@syscor.com>
> To:     Yves <yvenault@yahoo.ca>, pgsql-novice
> <pgsql-novice@postgresql.org>
> References:
> <20040716214143.14156.qmail@web41510.mail.yahoo.com>
>
>
>
> 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 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
>
>
>
>

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca