Postgres Pro
Downloads
Home   >   mailing lists

Re: psql copy command - 1 char limitation on delimiter - Mailing list pgsql-general

From Tom Lane
Subject Re: psql copy command - 1 char limitation on delimiter
Date
Msg-id 16194.1285423422@sss.pgh.pa.us
Whole thread Raw
In response to psql copy command - 1 char limitation on delimiter  (rey <reywang@optonline.net>)
Responses Re: psql copy command - 1 char limitation on delimiter  (rey <reywang@optonline.net>)
Re: psql copy command - 1 char limitation on delimiter  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view 
rey <reywang@optonline.net> writes:
> Why limit this to a single character?

Performance.  Believe it or not, breaking fields at the delimiter is
a significant factor in COPY speed.

            regards, tom lane

pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Listen and do something daemon
Next
From: Jeff Davis
Date:
Subject: Re: Index on points