Thanks for the input everyone. I'll try to comment on each discussion point:
1) garbled output in large queries I messed around with a few things, and have not been able to recreate any issues. Can you provide a test case for this? Also, any other interesting things about your terminal, like your $TERM setting, locale, etc. (I'm using xterm with UTF-8, and KDE's Konsole app) 2) %M vs shell call %M on when connected to the local machine displays the string "[local]" which I didn't like. I wanted a real hostname to show no matter which client/server pair I was using. Zero chance for mistaken commands on the wrong host. Many times we ssh to a remote server, then run psql locally. Perhaps the more elegant route here, is to change psql's behavior with %M when connected to the local machine? (This would also solve point #3) 3) a forked process for every prompt While this also isn't very elegant, it seems to work fine. It's not something to worry about these days when the server has 40 cores. ;-) But, I've noticed that different distros store lsof in different locations, so per-environment tweaking might be necessary. It would be nice if there was a way to do some kind of templating script with the psqlrc file. Something that would dynamically generate the "\set PROMPT" commands on psql startup, rather than calling out to a shell every command. (I'm thinking along the lines of ERB for Ruby, Django for Python, etc.) But again, I think the more elegant approach is to alter the %M logic. Any thoughts? Thanks! --Cal <c...@fbsdata.com> On Mon, Apr 25, 2016 at 9:39 AM, Francisco Olarte <fola...@peoplecall.com> wrote: > Hi: > > On Mon, Apr 25, 2016 at 4:04 PM, Achilleas Mantzios > <ach...@matrix.gatewaynet.com> wrote: > > Hello, have done that, looked really nice, but unfortunately this > resulted > > in a lot of garbled output, in case of editing functions, huge queries, > up > > arrows, etc... > > Did you use %[ %] to delimit non-printing sequences as Cal did? I've > tested his prompt ( substituting 'echo tarari' for his sh script ) and > it works fine ( at least in xfce4-terminal / ubuntu / 6 terminal lines > long input line ). I've seen a lot of color prompts worked by > forgetting them ( even when the doc for them specially speaks of color > changes ). > Frnacisco Olarte. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >