Re: pasting a lot of commands to psql

> 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 <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Dmitry Shalashov <skaurus(at)gmail(dot)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
>