Re: downloading booleans to CSV slow

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: downloading booleans to CSV slow
Date: 2009-10-12 08:57:14
Message-ID: 937d27e10910120157i186fa5c2q66f5eb80e5820193@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Mon, Oct 5, 2009 at 12:12 PM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
> Hi,
>
> Whenever i export a query to CSV that contains booleans, writing the
> data is exceptionally slow.
> I'm using pgAdmin 1.8.4 on ubuntu, it also occurs in several (all?)
> versions on windows.

Slow compared to what? Booleans (like numerics) should be quicker than
everything else because they are written as they come from the server.
Everything else will be slowed marginally because it must be quoted
and have any quotes in the data escaped.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message mohamed.baqer.altamimi 2009-10-12 12:27:17 PgAdmin iii
Previous Message Rhonalf Martinez Villa 2009-10-10 00:16:31 The server list is not saved