zhong ming wu <mr.z.m.wu@xxxxxxxxx> writes: > My .psql_history contains lines of the form. > select\040sum(price)\040from\040products\040p\040join\040 Yeah, that's what it will look like if psql is using Apple's libedit library; it's unrelated to the server. I think libedit doesn't support control-r either, not totally sure though. In any case there are some known bugs in libedit that Apple's not been terribly swift to fix. I'd suggest installing GNU readline and linking psql against that instead. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general