backslash in psql output - Mailing list pgsql-hackers

From Bruce Momjian
Subject backslash in psql output
Date
Msg-id 199810092024.QAA26179@candle.pha.pa.us
Whole thread Raw
List pgsql-hackers
I believe Tom Lane removed the double-backslash from the psql output by
modifying PQprint.

I recommend that is reversed, because psql escapes out the table column
delimiters with a single backslash, and now the format will be
ambigious.

    rtest=> create table test(x text);
    ERROR:  test relation already exists
    test=> create table test3(x text);
    CREATE
    test=> insert into test3 values ('\\x');
    INSERT 322185 1
    test=> select * from test3;
    x
    --
    \x
    (1 row)


This used to show as:

    x
    --
    \\x
    (1 row)

Comments?

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] dynamic libraries
Next
From: Tom Ivar Helbekkmo
Date:
Subject: Re: [HACKERS] Open 6.4 items