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:
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
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!
In response to
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2004-09-17 13:37:57|
|Subject: Re: Looking for postgres equivalent of mysqlimport|
|Previous:||From: Sean Davis||Date: 2004-09-17 13:13:05|
|Subject: Looking for postgres equivalent of mysqlimport|