Re: Copy From problem

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Copy From problem
Date: 2004-05-24 18:27:51
Message-ID: m3oeodfzun.fsf@conexa.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2004-05-24 18:31:21 Re: Copy From problem
Previous Message Eduardo Vázquez Rodríguez 2004-05-24 17:59:48 Copy From problem