Scott Marlowe wrote: > On Mon, Dec 15, 2008 at 11:02 PM, sai srujan <creativesrujan@xxxxxxxxx> wrote: >> Hi.... >> This is srujan and I am beginner of postgresql 8.1 and I have >> just stopped using mysql and i would like to use the dump (.sql file) >> created in it. I would like transfer the databases in my sql to postgresql >> 8.1. Please do reply. I am waiting for it. > > If possible, go ahead and jump right into 8.3.5. There's been quite a > few improvements over 8.1 in it. And unlike Oracle, when a new pg > version is released, it's considered to really be production ready > right away, or at least within a month or so. 8.3.5 is a year old > now, and we've been running 8.3 in production since 8.3.3 came out and > it's fantastic. > > The easiest way to transfer your database over is to dump the schema > first, and get that working on pgsql. If you go to the PG projects site and search for "mysql" you'll find some tools to help with this too. http://pgfoundry.org/ -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general