Skip site navigation (1) Skip section navigation (2)

Re: Database Conversion

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Conversion
Date: 2008-09-04 13:41:29
Message-ID: 200809041641.29301.achill@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-admin
Στις Thursday 04 September 2008 16:24:34 ο/η Carol Walter έγραψε:
> Hello, All,
> 
> I have a new faculty member who has a large database that is in  
> MySQL.  We don't support MySQL so the database needs to be ported to  
> PostgreSQL.  Her GA, who know MySQL, says that he has a query that he  
> will run that will put the data into postgres.  I thought that the  
> data would have to be output to a text file and then copied into  
> postgres.  I don't know MySQL.  I've done a conversion from Oracle  
> and this is how I did it.  Is he correct that he can put the data  
> into a postgres database by running a MySQL query?  It doesn't sound  
> possible to me.

If his query is like:

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

then it is possible

> 
> Carol
> 



-- 
Achilleas Mantzios

In response to

Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2008-09-04 13:43:42
Subject: Re: pg_dump etc. versions
Previous:From: Achilleas MantziosDate: 2008-09-04 13:38:03
Subject: Re: Database Conversion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group