copy command & null datetime - Mailing list pgsql-interfaces

From Ken J. Wright
Subject copy command & null datetime
Date
Msg-id 3.0.32.19990307190751.0088d650@ren.cncware.com
Whole thread Raw
Responses Re: [INTERFACES] copy command & null datetime  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Re: [INTERFACES] copy command & null datetime  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
The following example will cause COPY to fail on input:

xxx|yyy|zzz||aaa|bbb|

where the empty field in between zzz & aaa is of type datetime (don't know
about other types). I know a \N will fix this, but interpreting an empty
import field as NULL would certainly beef up COPY as other database systems
don't output the \N which is unique to PostgreSQL. Wish list item?

Ken


pgsql-interfaces by date:

Previous
From: "Ken J. Wright"
Date:
Subject: outer joins
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [INTERFACES] copy command & null datetime