BUG #13736: pg_dump should use E'' quotes

From: felipe(at)felipegasper(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13736: pg_dump should use E'' quotes
Date: 2015-10-26 20:48:47
Message-ID: 20151026204847.3021.73649@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13736
Logged by: Felipe Gasper
Email address: felipe(at)felipegasper(dot)com
PostgreSQL version: 9.4.5
Operating system: Linux
Description:

When dumping a DB whose name has a backslash in it, I get a warning like:

------
pg_dump: WARNING: nonstandard use of \\ in a string literal
LINE 1: ...) AS description FROM pg_database WHERE datname = 'i have / ...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
------

pg_dump should be using PostgreSQL’s own recommended syntax, should it not?
Is there anything that would break from making this change?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-10-26 21:33:06 Re: BUG #13736: pg_dump should use E'' quotes
Previous Message Jeff Janes 2015-10-26 19:17:06 Re: BUG #13723: "duplicate key" error occurs when update delete and insert the same row concurrently