Jeff Lanzarotta wrote:
Hello,
I have a MySQL dump file that I would like to import into our PostgreSQL
8.2 database. Is there a way to do this?
You'll need to convert the table definitions then the data.
For example, mysql has int(11) columns, postgres only has int columns.
I usually convert the tables, then do a csv dump from mysql:
select * from table into outfile '/path/to/file';
then import into postgres:
\copy table from '/path/to/file'
--
Postgresql & php tutorials
http://www.designmagick.com/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
