Re: pasting a lot of commands to psql

On 7/7/2016 12:48 PM, Alvaro Herrera wrote:
>> Agreed. I've looked at this problem extensively and concur that
>> >readline is the culprit; I don't think there's any solution on our end
>> >besides filing a bug with the readline. I also agree with the
>> >upthread suggestion that the best workaround today is to \e into a
>> >non-readline based editor (vim qualifies). Having said that, at least
>> >on linux/gnome, very long pastes can cause severe performance issues
>> >as well. So for large pastes I go with psql -f.
> Hmm, I was doing megabyte-long pastes (longest one over 5 MB) just a few
> weeks ago and was pleasantly surprised to discover that they worked just
> fine with no noticeable performance problem. I was pasting skype logs
> directly from the Linux skype client window into an xterm running cat,
> with obviously no readline involved.

yeah, long pastes generally work fine with ssh sessions, too, using ssh
clients like putty or securecrt.

--
john r pierce, recycling bits in santa cruz