| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Mohsen Pahlevanzadeh <mohsen(at)pahlevanzadeh(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org, mysql(at)lists(dot)mysql(dot)com |
| Subject: | Re: Reading from Mysql & writting in PGsql |
| Date: | 2005-02-28 18:33:32 |
| Message-ID: | 20050228183332.GA2426@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 tools in contrib: my2pg.pl and mysql2pgsql, and
of course you can use the database-independent access in your favorite
scripting language (DBI.pm in perl, for example) to attach to both
databases, then stream from one to the other.
HTH :)
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-02-28 18:44:13 | Re: row numbering |
| Previous Message | Peter Eisentraut | 2005-02-28 18:31:03 | Re: Possible to run the server with ANSI/ISO string escapeing |