Re: [GENERAL] Reading from Mysql & writting in PGsql

[Sean Davis]

You will have to export from mysql and then insert into postgresql.  If you 
are using postgresql 8 or above, you can use dbi-link 
(http://pgfoundry.org/projects/dbi-link/) to set up a view in your 
postgresql for the table in mysql and select directly from it.

Sean
----- Original Message ----- 
From: "Mohsen Pahlevanzadeh" <[EMAIL PROTECTED]>
To: <pgsql-general@postgresql.org>
Cc: <mysql@lists.mysql.com>
Sent: Sunday, February 27, 2005 6:27 PM
Subject: [GENERAL] Reading from Mysql & writting in PGsql


Dears,I need to read 1 field with select command from mysql.Then Write it
to pgsql.
Please guide me.....
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings