Re:

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2001-12-20 16:36:32
Message-ID: 3C221390.B970BAB@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Can anyone tell me where I can find documention on how to use mysql2pgsql?
> I downloaded the software conversion utility from www.pgsql.com.

Create a dump file from mysql, then give that file to mysql2pgsql (use
the --help option to see other possible parameters). Write the output to
a file:

mysql2pgsql --verbose dumpfile > pgsql.dump

The output file will work as-is or with some modifications to give you
something you can pipe to psql:

psql -e yourdb < pgsql.dump

Good luck!

- Thomas

In response to

  • at 2001-12-20 16:00:27 from Peter E. Chen

Browse pgsql-general by date

  From Date Subject
Next Message Hunter Hillegas 2001-12-20 16:44:32 JDBC Driver Munging My Text?
Previous Message Aasmund Midttun Godal 2001-12-20 16:23:44 Re: Security Question . . .