On Tue, 16 Aug 2011, Chris Travers wrote:
What kind of error?
Chris,
Here's the full statement for the last row:
psql:chem_too.sql:5517: ERROR: invalid input syntax for type boolean: ""
LINE 1: ...NS','1996-11-21','Potassium','0.949999988','mg/L','','','','...
^
The column is NULLable and if there's no value a NULL should be entered.
Do you get the same error by running psql interactively and typing \i
filename.sql?
Er, thanks for the pointer. I didn't read the psql man page first. Now I'm
using 'psql -f <filename> <database_name>' and getting the above error.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
