Re: BUG #15474: Special character escape sequences need betterdocumentation, or more easily found documentation - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #15474: Special character escape sequences need betterdocumentation, or more easily found documentation
Date
Msg-id CAKFQuwZqDz032iap1+yyWf+NLmW=0aV+NyUFB-hnrwx=gXJDsg@mail.gmail.com
Whole thread Raw
In response to BUG #15474: Special character escape sequences need betterdocumentation, or more easily found documentation  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Wednesday, October 31, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:
A simple table elaborating on
the escapes for each special character would be incredibly helpful at
determining how to translate those escapes for cleaning strings prior to
insertion so those of us using postgresql can quickly write cleaning
functions for data.

Translating escapes and writing cleaning functions should be a rare need unless you are writing driver-level code.  Applications should avoid caring about either by avoiding dynamic sql altogether or using quote_* functions or the format function.

David J.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #15474: Special character escape sequences need betterdocumentation, or more easily found documentation
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #15474: Special character escape sequences need better documentation, or more easily found documentation