Re: INSERTing rows from external file - Mailing list pgsql-general

From Scott Ribe
Subject Re: INSERTing rows from external file
Date
Msg-id 76303302-042C-43A7-8A17-57329AD1598C@elevated-dev.com
Whole thread Raw
In response to Re: INSERTing rows from external file  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Aug 16, 2011, at 4:13 PM, Rich Shepard wrote:

> 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.

An empty string is not null.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: INSERTing rows from external file
Next
From: "David Johnston"
Date:
Subject: Re: INSERTing rows from external file