Re: Postgres SQL Syntax - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Postgres SQL Syntax
Date
Msg-id pu7iuvd2q7.fsf@srv.protecting.net
Whole thread Raw
In response to Postgres SQL Syntax  ("Jim C." <jlistnews@gmail.com>)
List pgsql-general
In article <epvm6a$9ee$1@sea.gmane.org>,
"Jim C." <jlistnews@gmail.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.

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: accidentally deleted user --> postgres
Next
From: Richard Huxton
Date:
Subject: Re: table updated status