I'm trying to find the documentation of a complete list of escape sequences for string data types in Postgresql. So for example, if you need to escape a quote character inside of a quoted string, you would use
\". Different DBMSs use different jargon, so I'm having a hard time finding what to search for.
I found this, but it doesn't look exhaustive to me. In this link, search for "The following special backslash sequences are recognized by COPY FROM".
I knew it wasn't exhaustive. See the
\\ character here:
Then look at "220.127.116.11. String Constants with C-style Escapes" in this link. Also read what's written in CAUTION. This is making me humble, and I hope it is for others.