Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] backslash in psql output

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: lockhart(at)alumni(dot)caltech(dot)edu (Thomas G(dot) Lockhart)
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] backslash in psql output
Date: 1998-10-10 05:20:57
Message-ID: 199810100520.BAA17393@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> We can include a command-line option to re-enable the escapes. Anyone
> can use that form, and can define an alias for it if they need.
> 
> I understand your concern about backward compatibility, but imho the
> convention it was using makes things more confusing, especially for a
> new user. I'm not certain (assuming things have changed recently) that
> the new behavior is what I would want, but the old behavior was not one
> I would have guessed at.
> 
> Using psql to pipe output to another program is the best example of why
> one might _not_ want to re-escape the strings. If the goal is to use
> data from the database, then that data is what you will want to see in
> the pipe.
> 
> Anyway, in the long run I'd like to consider moving toward a "no-escape"
> default output for psql. If you think that it is too short notice to
> fully understand the ramifications of a change this close to release, or
> if your "faithful correspondents" have cottage cheese for brains, then
> go ahead and revert it ;) But I like the new behavior in principle...
> 
>                     - Tom
> 
> Another possibility is to make it a configuration option:
> 
>   ./configure --enable-psql-string-escapes
> 
> or something like that...
> 

I realize the double-backslash is confusing, but I don't think we can
make such a user-visible change at this time.  I think we need to open
discussion on this issue on the general list, and to include discussion
of NULL displays, and any other issues, as well as how to properly
output the column separation character if that appears in the data.

So, I think we have to put it back to the old way, and open discussion
about this after 6.4.

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


In response to

pgsql-hackers by date

Next:From: Paul A VixieDate: 1998-10-10 05:34:08
Subject: Re: [HACKERS] Open 6.4 items
Previous:From: Thomas G. LockhartDate: 1998-10-10 04:37:37
Subject: Re: [HACKERS] Portability Issue in src/backend/port/snprintf.c (I think)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group