downloading booleans to CSV slow

[Willy-Bas Loos-2]

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.

Cheers,

WBL

--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[Dave Page-7]

On Mon, Oct 5, 2009 at 12:12 PM, Willy-Bas Loos <willybas@...> 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

--
Sent via pgadmin-support mailing list (pgadmin-support@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support