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@sandia.gov>
To: "'David Reid'" <dreid@jetnet.co.uk>; <pgsql-general@postgresql.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@sandia.gov
>
>
> > -----Original Message-----
> > From: David Reid [mailto:dreid@jetnet.co.uk]
> > Sent: October 19, 2000 5:31 AM
> > To: pgsql-general@postgresql.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
> >
>
>