Re: Looking for postgres equivalent of mysqlimport

From: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: Postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Looking for postgres equivalent of mysqlimport
Date: 2004-09-17 16:15:12
Message-ID: a06110412bd70bd647413@[192.168.0.243]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

At 9:37 AM -0400 9/17/04, Sean Davis wrote:
>Marc,
>
>Thanks. That is what I had thought. Another detail--I have fields
>(including some dates) that include "" (empty fields). What is the
>best way to deal with those? Should I just convert them to NULL
>(assuming that was the actual meaning) and then use that as the NULL
>string in the copy command?

Sean,

I think you could try that. You may leave them empty as well (after
stripping '"') and use that for NULL with the COPY command.

Marc

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-09-17 16:31:47 Re: Looking for postgres equivalent of mysqlimport
Previous Message Tom Lane 2004-09-17 15:01:44 Re: Installation problem...