> 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
> 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.
2016-07-07 20:37 GMT+03:00 Tom Lane <tgl@xxxxxxxxxxxxx>:
Dmitry Shalashov <skaurus@xxxxxxxxx> 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
