I have an enormous sql script with an incorrect insert line somewhere. I can echo the commands to stdout as they are executed, but apparently errors go to stderr. How can I determine where the problem is?
from memory, if you invoke it from the shell with psql [connection options] -f filename.sql you'll get the line number of filename.sql that has the error. Good luck, Stuart.
