Title: RE: Export tab delimited from mysql to postgres.
Thankyou all for your advice,
Looking further into the issue I have realised that "data and formatting" lines are denoted by the same CR/LF symbols. So if I where to replace all CR/LF symbols it would create a file with one line... I ha
Theo Galanakis <[EMAIL PROTECTED]> writes:
> As you can see row 2 has a value that holds a CR value which ends up
> wrapping around onto the third line. Postgres copy command does not like
> this and mysql is unable to replace the value with another type of
> delimiter, like a \r.
> So I gather I
topher Browne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 12 October 2004 10:46 AM
To: [EMAIL PROTECTED]
Subject: Re: [SQL] Export tab delimited from mysql to postgres.
Quoth [EMAIL PROTECTED] (Theo Galanakis):
Could you provide a example of how to do this?
I actually ended up exporting the d
Title: RE: [SQL] Export tab delimited from mysql to postgres.
Thanks for all your comments,
I have beent trying the insert within a transaction block, however it does not seem to reduce the time it takes to process each records. Mind you there are 80 column and the insert statement
Quoth [EMAIL PROTECTED] (Theo Galanakis):
> Could you provide a example of how to do this?
>
> I actually ended up exporting the data as Insert statements,
> which strips out cf/lf within varchars. However it takes an eternity
> to import 200,000 records... 24 hours infact Is th
On Tue, Oct 12, 2004 at 09:23:41 +1000,
Theo Galanakis <[EMAIL PROTECTED]> wrote:
>
> Could you provide a example of how to do this?
>
> I actually ended up exporting the data as Insert statements, which
> strips out cf/lf within varchars. However it takes an eternity to import
> 20
Title: RE: [SQL] Export tab delimited from mysql to postgres.
Could you provide a example of how to do this?
I actually ended up exporting the data as Insert statements, which strips out cf/lf within varchars. However it takes an eternity to import 200,000 records... 24
In article <[EMAIL PROTECTED]>,
Theo Galanakis <[EMAIL PROTECTED]> writes:
> Has anyone been able to export and import a tab delimited file from mysql to
> postgres successfully?
> This is my dilemma which I have posted on mysql sites with no response,
> however postgres users may have come across
