MySQL Forums
Forum List  »  PostgreSQL

Re: Postgresql to mysql
Posted by: Leo Gil
Date: August 02, 2004 07:44PM

Radhika,

I believe the easier way would be to export all the data to a csv file and import it to MySQL.
This way you can manipulate the data within your text file if you need (It's a good 'vi' exercise 8-) )
When you are migrating your table structure just be careful if you are using 'sequences' on postgres, MySQL has an easier way of working with them which is 'auto_increment'.

Good luck,

Leo

Options: ReplyQuote


Subject
Views
Written By
Posted
12218
July 16, 2004 12:28PM
Re: Postgresql to mysql
9873
August 02, 2004 07:44PM
9082
February 03, 2008 05:32PM
9544
September 18, 2008 03:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.