Re: NULL TIMESTAM problem

["Guy Rouillier" <guyr@xxxxxxxxxxx>]

Enrique Sánchez wrote:
> Hi! I'm new in Postgres.
> 
> I nedd to fill a database table x from a file With the COPY command
> an the delimiter '*'.
> This  table  has a timestamp null column (I declared like: ' birthday
> timestamp NULL' ).
> 
> But when I try to insert NULL values(specified in the file), postgres
> throw an error.
> 
> 
> I don't know how can I specify this NULL value wkthout an '\N'
> character. 

I created a table t1 with 3 columns, all nullable:

	f1 int
	f2 timestamp
	f3 int

Using the following input file t1.csv:

	5,NULL,7
	8,NULL,10

The following COPY command successfully put those rows in the table, with f2 null:

	copy t1 (f1, f2, f3)
	from 't1.csv'
	null as 'NULL'
	csv;

-- 
Guy Rouillier