Re: COPY formatting - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: COPY formatting
Date
Msg-id 405B62A7.7020809@dunslane.net
Whole thread Raw
In response to Re: COPY formatting  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:

>OK, so for the separator, quote, and escape options:
>
>    separator is ,
>    quote is "
>    escape is "
>
>so if the quote and escape are the same, then a double denotes a
>single?
>
>  
>

Yes. i.e. with the above settings "abc""def" -> abc"def

cheers

andrew



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: COPY formatting
Next
From: Kevin Brown
Date:
Subject: Re: [PERFORM] fsync method checking