On Thu, Mar 09, 2006 at 12:49:14PM -0600, Enrique Sánchez wrote: > 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. What's the error? How are the NULL values specified in the file? > I don't know how can I specify this NULL value wkthout an '\N' character. See the COPY documentation -- COPY has a NULL option that allows you to specify what string should be interpreted as NULL. Recent versions also have a CSV option that interprets empty strings as NULL. http://www.postgresql.org/docs/8.1/interactive/sql-copy.html (Use the documentation for whatever version you're running.) -- Michael Fuhr
