Steve Crawford wrote: > On 09/25/2010 07:03 AM, Tom Lane wrote: > > rey<reywang@xxxxxxxxxxxxx> 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 > > > > > I agree that that multi-character (or even regex) delimiters would be > useful. Would it be reasonable for the copy process to differentiate > between single character delimiters which could be processed in > "high-speed" mode and multi-character or regex delimiters which would be > available as needed albeit at the expense of a performance hit? I am not sure you are aware but Postgres never confuses delimiters from data because it uses a backslash before literal data that matches delimiters. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
