Commite9a79c2

committed

doc: \123 and \x12 escapes in COPY are in database encoding.

The backslash sequences, including \123 and \x12 escapes, are interpretedafter encoding conversion. The docs failed to mention that.Backpatch to all supported versions.Reported-by: Andreas GrobDiscussion:https://www.postgresql.org/message-id/17142-9181542ca1df75ab%40postgresql.org

1 parent6f8127b commite9a79c2Copy full SHA for e9a79c2

File tree

-2

lines changed

-2

lines changed

Lines changed: 8 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -636,12 +636,12 @@ COPY <replaceable class="parameter">count</replaceable>`
`636`	`636`	`<row>`
`637`	`637`	`<entry><literal>\</literal><replaceable>digits</replaceable></entry>`
`638`	`638`	`<entry>Backslash followed by one to three octal digits specifies`
`639`		`- thecharacter with that numeric code</entry>`
	`639`	`+ thebyte with that numeric code</entry>`
`640`	`640`	`</row>`
`641`	`641`	`<row>`
`642`	`642`	`<entry><literal>\x</literal><replaceable>digits</replaceable></entry>`
`643`	`643`	`<entry>Backslash <literal>x</literal> followed by one or two hex digits specifies`
`644`		`- thecharacter with that numeric code</entry>`
	`644`	`+ thebyte with that numeric code</entry>`
`645`	`645`	`</row>`
`646`	`646`	`</tbody>`
`647`	`647`	`</tgroup>`
`@@ -673,6 +673,12 @@ COPY <replaceable class="parameter">count</replaceable>`
`673`	`673`	`or vice versa).`
`674`	`674`	`</para>`
`675`	`675`
	`676`	`+ <para>`
	`677`	`+ All backslash sequences are interpreted after encoding conversion.`
	`678`	`+ The bytes specified with the octal and hex-digit backslash sequences must`
	`679`	`+ form valid characters in the database encoding.`
	`680`	`+ </para>`
	`681`	`+`
`676`	`682`	`<para>`
`677`	`683`	`<command>COPY TO</command> will terminate each row with a Unix-style`
`678`	`684`	`newline (<quote><literal>\n</literal></quote>). Servers running on Microsoft Windows instead`

Comments

(0)