Postgres Pro
Downloads
Home   >   mailing lists

BUG #13736: pg_dump should use E'' quotes - Mailing list pgsql-bugs

From felipe@felipegasper.com
Subject BUG #13736: pg_dump should use E'' quotes
Date
Msg-id 20151026204847.3021.73649@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13736: pg_dump should use E'' quotes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13736
Logged by:          Felipe Gasper
Email address:      felipe@felipegasper.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?

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #13723: "duplicate key" error occurs when update delete and insert the same row concurrently
Next
From: Tom Lane
Date:
Subject: Re: BUG #13736: pg_dump should use E'' quotes