From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
Date: Thu, 4 Sep 2008 16:41:29 +0300
User-Agent: KMail/1.9.7
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
In-Reply-To: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200809041641.29301.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Thursday 04 September 2008 16:24:34 =CE=BF/=CE=B7 =
Carol Walter =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello, All,
>=20
> I have a new faculty member who has a large database that is in =20
> MySQL.  We don't support MySQL so the database needs to be ported to =20
> PostgreSQL.  Her GA, who know MySQL, says that he has a query that he =20
> will run that will put the data into postgres.  I thought that the =20
> data would have to be output to a text file and then copied into =20
> postgres.  I don't know MySQL.  I've done a conversion from Oracle =20
> and this is how I did it.  Is he correct that he can put the data =20
> into a postgres database by running a MySQL query?  It doesn't sound =20
> possible to me.

If his query is like:

SELECT 'INSERT INTO PostgreSqlTable(...) VALUES(''||somevalue...||'')' FROM=
 mysqltable ....

then it is possible

>=20
> Carol
>=20


=2D-=20
Achilleas Mantzios