Explicit NULL for no INTEGER data?

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

  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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general