Explicit NULL for no INTEGER data?
I have a data file I want to copy into a table. The column name and
attribute is:
depth_seal INTEGER
one of the rows in the .csv file I want to bring into the table has no value
for this column, but there is no explicit NULL in the text file. When I try
to copy the file psql complains:
ERROR: invalid input syntax for integer: ""
CONTEXT: COPY water_well, line 1, column depth_seal: ""
Do I need an explicit NULL in that column?
Rich
On Fri, 18 Feb 2011, Rich Shepard wrote:
Do I need an explicit NULL in that column?
Update: Placing NULL or a blank produces the same error.
How should I represent no value for an integer column in a .csv file?
Rich
Judging from:
http://www.postgresql.org/docs/8.1/static/sql-copy.html
It looks like you have to specify your own NULL string with the NULL
AS parameter of the COPY command.
Show quoted text
On Fri, Feb 18, 2011 at 3:12 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
On Fri, 18 Feb 2011, Rich Shepard wrote:
Do I need an explicit NULL in that column?
Update: Placing NULL or a blank produces the same error.
How should I represent no value for an integer column in a .csv file?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, 18 Feb 2011, Mike Christensen wrote:
It looks like you have to specify your own NULL string with the NULL
AS parameter of the COPY command.
Mike,
I completely missed that option when I've read the copy page. My
apologies!
Rich
It looks like you have to specify your own NULL string with the NULL
AS parameter of the COPY command.Mike,
I completely missed that option when I've read the copy page. My
apologies!Rich
Awesome, I'm the one usually asking easy questions on this mailing
list so I'm just glad I could answer one for once!