On Saturday, September 19, 2026, PG Doc comments form < [email protected]> wrote:
> The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/18/functions-string.html > Description: > > >> Here are some examples of the basic format conversions: > > ```html > SELECT format('INSERT INTO %I VALUES(%L)', 'locations', 'C:\Program > Files'); > Result: INSERT INTO locations VALUES('C:\Program Files') > ``` > > ```sql > db=# SELECT format('INSERT INTO %I VALUES(%L)', 'locations', 'C:\Program > Files'); > > format > ---------------------------------------------------- > INSERT INTO locations VALUES(E'C:\\Program Files') > ``` > Indeed, the example doesn’t reflect the actual output since the presence of a backslash prompts format to produce syntax for an escape string. I don’t see a point for explaining when it may choose to write an escape string but the examples should match reality. I’d back-patch this to supported versions on that basis. David J.
