| From: | Harald Fuchs <hf1110x(at)protecting(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres SQL Syntax |
| Date: | 2007-02-06 10:01:20 |
| Message-ID: | pu7iuvd2q7.fsf@srv.protecting.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In article <epvm6a$9ee$1(at)sea(dot)gmane(dot)org>,
"Jim C." <jlistnews(at)gmail(dot)com> writes:
> Maybe it is and maybe it isn't. I wouldn't know. I'm merely the
> unfortunate soul chosen to convert this from MySQL to Postgres. :-/
> I've been working on it for a week now. I've got to say that it pains me
> to know that there is apparently no open standard in use for
> importing/exporting data from one db to another.
Regarding just the data, you could use "mysqldump --tab=DIR" on the
MySQL side and "COPY FROM" on the PostgreSQL side.
> XML would do the job, wouldn't it?
If you have a problem and try to solve it with XML, then you have two problems.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Dorbath | 2007-02-06 11:27:17 | Retrieving affected tables |
| Previous Message | Shane Ambler | 2007-02-06 10:01:03 | Re: accidentally deleted user --> postgres |