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 e
unsubscribe pgsql-sql
Mensagem Enviada utilizando o Onda Mail.
http://www.onda.com.br
Onda Provedor de Servicos S/A
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
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 hours
Am Sonntag, 10. Oktober 2004 15:01 schrieb Marc G. Fournier:
> On Sun, 10 Oct 2004, Janning Vygen wrote:
> > Am Sonntag, 10. Oktober 2004 02:43 schrieb Marc G. Fournier:
> >> On Sat, 9 Oct 2004, Tom Lane wrote:
> >>> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Have a table with two FKs on
Hi folks.
I'm annoyed that I can't sus out something this simple.
The join below gives the output I want, but I can't work out how to
convert it to be an update on the requests field.
I want to append the customer name to the fuel (delivery details) field
and then update the customer field to
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
Gaetano Mendola wrote:
sreejith s wrote:
Hi friends,
I problem is i want to add a specified no. of years to a
given date
ie, 12/12/2004 + 5 = 12/12/2009. This has to be done via sql. Any
predefined function there for the same. or v have split the yr and
then add.
Sreejith
# select '
