Re: pasting a lot of commands to psql - Mailing list pgsql-general

From Tom Lane
Subject Re: pasting a lot of commands to psql
Date
Msg-id 23146.1467913033@sss.pgh.pa.us
Whole thread Raw
In response to pasting a lot of commands to psql  (Dmitry Shalashov <skaurus@gmail.com>)
Responses Re: pasting a lot of commands to psql
Re: pasting a lot of commands to psql
List pgsql-general
Dmitry Shalashov <skaurus@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


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: pasting a lot of commands to psql
Next
From: Sameer Kumar
Date:
Subject: Re: pasting a lot of commands to psql