I type the command psql -d postgis -h localhost -U postgres -f nhd_area.sql and I get a whole list of errors. They read psql:nhd_area.sql:1749: ERROR: current transaction is aborted, commands ignored until end of transaction block. The 1749 starts at 1 and eventually I get an abort program screen.
Please help.
how large is the nhd_area.sql file? I'm assuming there is a bad character of some sort. The error is on line 1749. If you get notepad++ (thats what I use to open large files) you can go to the line. If the file is too large to email (try zipping it, that'll help then send to services @ gpsfiledepot.com (remove the spaces around @)), just copy that line here and I can most likely figure it out quickly.