>
> If you say that psql accepts only limited amount of data from its stdin,
> it is more of its problem, rather than pipe's. To check it, try to feed
> the big file to psql via redirection, like in:

It's not, psql is commonly used to restore whole databases by feeding
it data from stdin.