"Tomi NA" <hefest@xxxxxxxxx> writes: > 2006/10/31, Albe Laurenz <all@xxxxxxxxxxxxxxxxx>: >> psql -h host -p port -d database -U user <dump.sql > It's a good enough solution in most cases, but when the rowcount > starts to skyrocket, it simply doesn't seem to cut it (at least I > couldn't make it to). It certainly should work. We've seen some platforms where libreadline seems to be unable to tell the difference between input from a terminal and input from a file, and performs a boatload of processing that would be useful for interactive input but is just overhead here. If that's your problem, try this form instead: psql -h host -p port -d database -U user -f dump.sql regards, tom lane
