-----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Rich Shepard Sent: Tuesday, August 16, 2011 6:14 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: INSERTing rows from external file 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, ---------------------------------------------------------------------------- --------- Since the error references a specific row of data you should provide that as well. Your INSERT statement is syntactically incorrect; the error has nothing to do with PSQL other than the fact that PSQL is reporting the error to you. Odds are you are wrapping your Boolean input with single quotes and the empty string is not valid input for a Boolean. Because of the quotes the system will not use NULL since the input data is not missing but instead it has the empty-string as a value. David J. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
