Re: Looking for postgres equivalent of mysqlimport

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

On Sep 17, 2004, at 9:28 AM, M. Bastin wrote:

> At 9:13 AM -0400 9/17/04, Sean Davis wrote:
>> I am looking for the rough equivalent of:
>>
>> mysqlimport -L -h <host> -r --fields-terminated-by=',' -u<user>
>> -p<pass>
>> --fields-enclosed-by='"' genekeydb *csv >report
>>
>> In particular, I have '"' enclosed fields.
>
> As far as I know there's nothing to determine enclosed fields with
> postgresql and you'll have to trim these '"' off after the import.
>
> For the import, what you're looking for is COPY TO/FROM ...
>
> Here's the documentation on COPY:
> <http://www.postgresql.org/docs/7.4/interactive/sql-copy.html>
>
> If this is a one time operation that you don't need to program into
> your solution you can easily do it with Eduphant from any Win or Mac
> client:  <http://aliacta.com/download>
> In Eduphant, click the "stdin" button to select the file you want to
> import, then type the appropriate COPY command and execute it.
>
> General caveat on imports: make sure you don't mix up text encodings!
>
> Cheers,
>
> Marc