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

2005-02-28 Thread David Fetter
On Sun, Feb 27, 2005 at 03:27:48PM -0800, Mohsen Pahlevanzadeh wrote: > Dears,I need to read 1 field with select command from mysql. Then > Write it to pgsql. Please guide me. If you need to do this directly, look into dbi-link. http://pgfoundry.org/projects/dbi-link/ There are conversion

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

2005-02-28 Thread 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 -

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

2005-02-27 Thread Troels Arvin
On Sun, 27 Feb 2005 15:27:48 -0800, Mohsen Pahlevanzadeh wrote: > Dears,I need to read 1 field with select command from mysql.Then Write it > to pgsql. Which programming environment? Java/php/perl/c/...? -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of b