NULL TIMESTAM problem

From: "Enrique Snchez" <sancheztru(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: NULL TIMESTAM problem
Date: 2006-03-09 18:49:14
Message-ID: BAY113-F31F49E5C80E9ECEAA5BF8AD4EC0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Thanks
Enrique.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Kratz 2006-03-09 18:49:41 Re: multi-column aggregates
Previous Message Tom Lane 2006-03-09 18:08:45 Re: multi-column aggregates