Re: MySQL -> pgsql

OK. Thanks to all who replied. Here are my first impressions...

- pgsql is fussier about names of columns than mysql. e.g. a column name of
position was rejected by pgsql but seems to be OK in mysql.
- PRIMARY_KEY() syntax is OK for pgsql (which was a relief)
- There seem to be a lot more types in mysql than pgsql.

Questions that have cropped up already!!

- can tinyint(4) be considered to be int4?
- what should an int(11) be?
- if it uses "int(11) DEFAULT 0 NOT NULL auto_increment" is that
functionally the same as serial?
- is there an easy way to duplicate enums? this is one of the ones I need
to copy...
"enum('R','L') DEFAULT 'R' NOT NULL"

I'll try to put all the help I get and my findings into a web page and make
it available if people feel it would be useful. Of course a tool to
automatically convert would be brilliant, but that's far off into the future
for me! :)

Oh, and I've subscribed now!

david

----- Original Message -----
From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: "'David Reid'" <dreid(at)jetnet(dot)co(dot)uk>; <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, October 19, 2000 8:03 PM
Subject: RE: [GENERAL] MySQL -> pgsql

> I'm also interested, so could you post to the list?
>
> Thanx,
> Mike Diehl,
> Network Monitoring Tool Devl.
> 284-3137
> jdiehl(at)sandia(dot)gov
>
>
> > -----Original Message-----
> > From: David Reid [mailto:dreid(at)jetnet(dot)co(dot)uk]
> > Sent: October 19, 2000 5:31 AM
> > To: pgsql-general(at)postgresql(dot)org
> > Subject: [GENERAL] MySQL -> pgsql
> >
> >
> > Can someone point me at any resources on the web that can
> > help with such a
> > transformation? I have a series of tables I want to convert. Thanks.
> >
> > Oh, and I'm not on the list so can you email direct! :)
> >
> > david
> >
>
>