> Yeah, I've noticed there's a limit on the amount you can paste into psql, > at least on some platforms. AFAICT this must be a readline > bug/limitation, or maybe something about the X cutbuffer protocol
That would be sad... Actually if you don't know the answer then I suppose I can't do anything about this issue :-) Gotta use another approaches like \i. However I have to add that this glitch could happen after five lines or twenty lines, not really looks like some hard limit of something. Initially I suspected that "INSERT 0 1" answers after each statement got in the way, but `\set QUIET` didn't solved this problem. Dmitry Shalashov, surfingbird.ru & relap.io 2016-07-07 20:37 GMT+03:00 Tom Lane <t...@sss.pgh.pa.us>: > Dmitry Shalashov <skau...@gmail.com> writes: > > Let say that I have some sql file with like hundred of simple statements > in > > it. I `cat` it, copy it to buffer, go to my beloved psql and insert it > > there. > > But somewhere after first few lines it screws over: > > Yeah, I've noticed there's a limit on the amount you can paste into psql, > at least on some platforms. AFAICT this must be a readline > bug/limitation, or maybe something about the X cutbuffer protocol; > there's nothing in psql itself that would even know that a paste is > happening. > > You might have better luck with "psql -n", or maybe not. > > regards, tom lane >