[GENERAL] NULL TIMESTAM problem

[Enrique S�nchez]

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.



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] NULL TIMESTAM problem

[Enrique S�nchez]

OK.  the error was that: postgress didn't recognize which was the 
NULLstring, because the format file was: value1*value2**value4, where the 
delimiter is: * .


I learnd the default NULL string is '\N', but as you told me, you can 
specify this in the command definition.


Thanks Michael.



From: Michael Fuhr [EMAIL PROTECTED]
To: Enrique Sánchez [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] NULL TIMESTAM problem
Date: Thu, 9 Mar 2006 12:26:10 -0700

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

---(end of broadcast)---
TIP 6: explain analyze is your friend




---(end of broadcast)---
TIP 6: explain analyze is your friend

[GENERAL] null timestamp

[Enrique S�nchez]

Hola soy novato en postgres.

Necesito llenar una tabla xcon los datos contenidos en un archivo. Estoy utilizando el comando COPY. La cuestión es que no me permite introducir valores nulos en un campo de tipo timestamp, siendoque ya declare el tipo de dicho campo como nulo.


Alguiien sabe de esto?
saludos.