now I managed to dump table schema with pg_dump. However, is there any schema converting tool available? I don't want to edit each table schema to make it mysql-compliant.
Ideas? Pahud On Mon, 18 Oct 2004 12:23:41 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > On Mon, 18 Oct 2004 18:08:24 +0800, èææ Patrick Hsieh wrote: > > > > I am planing to transfer data from postgresql to mysql. Is there any > > useful tools, scripts or utilities to achieve this? > > pg_dump > > First dump the schema, edit that until you have something MySQL > understands. Then dump the data using the -d option so you have full > inserts instead of the usual COPY syntax and feed the file to the > MySQL command line client. > > Jochem > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Patrick Hsieh(èææ) <[EMAIL PROTECTED]> MSN: [EMAIL PROTECTED] | ICQ: 97133580 Skype: pahud_at_pahud.net | YIM: pahudnet pub 1024D/203F7DF1 2001/12/25 Patrick Hsieh (Pahud) <[EMAIL PROTECTED]> http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x203F7DF1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]