Re: MySQL -> pgsql
От | David Reid |
---|---|
Тема | Re: MySQL -> pgsql |
Дата | |
Msg-id | 00e201c03a1c$e70343a0$0a1aa8c0@godzilla обсуждение исходный текст |
Ответ на | RE: MySQL -> pgsql ("Diehl, Jeffrey" <jdiehl@sandia.gov>) |
Ответы |
Re: MySQL -> pgsql
|
Список | pgsql-general |
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 > > > >
В списке pgsql-general по дате отправления: