Re: [GENERAL] Trying to load MySQL data

2007-01-11 Thread Scott Marlowe
On Wed, 2007-01-10 at 16:51, [EMAIL PROTECTED] wrote: > The missing quote after Poster is a mistake I made when sanitzing the > data for posting here. That error is NOT present in the actual data. > There is a quote where needed in the data. So, with that in mind, why > am I still getting the error

Re: [GENERAL] Trying to load MySQL data

2007-01-11 Thread [EMAIL PROTECTED]
The missing quote after Poster is a mistake I made when sanitzing the data for posting here. That error is NOT present in the actual data. There is a quote where needed in the data. So, with that in mind, why am I still getting the error? Also, there is no symbol we can expect to not be in the dat

Re: [GENERAL] Trying to load MySQL data

2007-01-11 Thread Merlin Moncure
On 1/11/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: Merlin Moncure wrote: > On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a ?crit: > > > I am working on a project where we are converting from MySQL to > > > Postgres.

Re: [GENERAL] Trying to load MySQL data

2007-01-11 Thread Bruce Momjian
Merlin Moncure wrote: > On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a ?crit: > > > I am working on a project where we are converting from MySQL to > > > Postgres. I figured the easiest way would be to export the MySQL

Re: [GENERAL] Trying to load MySQL data

2007-01-11 Thread Merlin Moncure
On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote: Hi, Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a écrit: > I am working on a project where we are converting from MySQL to > Postgres. I figured the easiest way would be to export the MySQL data > as CSV. If you are using pg 8.2+

Re: [GENERAL] Trying to load MySQL data

2007-01-10 Thread Dimitri Fontaine
Hi, Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a écrit : > I am working on a project where we are converting from MySQL to > Postgres. I figured the easiest way would be to export the MySQL data > as CSV. You could also give pgloader a try. It uses COPY but allows you to load good data

Re: [GENERAL] Trying to load MySQL data

2007-01-10 Thread Walter Vaughan
[EMAIL PROTECTED] wrote: Hello, I am working on a project where we are converting from MySQL to Postgres. I figured the easiest way would be to export the MySQL data as CSV. I dunno, but unless you don't really care about your data, I'd use something that you have no chance of in your data.

Re: [GENERAL] Trying to load MySQL data

2007-01-10 Thread brian
[EMAIL PROTECTED] wrote: Hello, I am working on a project where we are converting from MySQL to Postgres. I figured the easiest way would be to export the MySQL data as CSV. I'm having a problem importing some of the data. What I have done is exported the MySQL data and then modified it so that

Re: [GENERAL] Trying to load MySQL data

2007-01-10 Thread Scott Marlowe
On Tue, 2007-01-09 at 19:54, [EMAIL PROTECTED] wrote: > Hello, > > I am working on a project where we are converting from MySQL to > Postgres. I figured the easiest way would be to export the MySQL data > as CSV. > > I'm having a problem importing some of the data. What I have done is > exported

[GENERAL] Trying to load MySQL data

2007-01-10 Thread [EMAIL PROTECTED]
Hello, I am working on a project where we are converting from MySQL to Postgres. I figured the easiest way would be to export the MySQL data as CSV. I'm having a problem importing some of the data. What I have done is exported the MySQL data and then modified it so that all single quotes (a ' quo