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. On Fri, Feb 18, 2011 at 3:12 PM, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
