Re: Copy From problem - Mailing list pgsql-novice

From Manuel Sugawara
Subject Re: Copy From problem
Date
Msg-id m3oeodfzun.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Copy From problem  (Eduardo Vázquez Rodríguez<evazquez@insys-corp.com.mx>)
List pgsql-novice
Eduardo Vázquez Rodríguez <evazquez@insys-corp.com.mx> writes:

> My question is how can I insert a null value into the field
> email,and that "copy from" continue copying the next lines?

Use \N to represent the null value, for instance (following your
notation (\t) to represent the tab char).

Jessie Rodriguez (\t) West Beach (\t) \N

Regards,
Manuel.

pgsql-novice by date:

Previous
From: Eduardo Vázquez Rodríguez
Date:
Subject: Copy From problem
Next
From: Nabil Sayegh
Date:
Subject: Re: Copy From problem