Thread: importing tab delimited, text enclosed by "

I have a file of data that is tab delimited, with text
fields enclosed by quotation marks.

I know I can use the copy command to load the data;
and that tab delimited is the default.  How do I tell
Postgres to remove the quotation marks?

I'm running PostgreSQL 7.0.2 on Linux (Caldera
eDesktop 2.4)

Thanks,

Andrew Gould

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Andrew Gould wrote:
>
> I have a file of data that is tab delimited, with text
> fields enclosed by quotation marks.
>
> I know I can use the copy command to load the data;
> and that tab delimited is the default.  How do I tell
> Postgres to remove the quotation marks?

It is probably easiest to remove the quote with a script
(like the following perl program).

while(<>){
    chop;
    @a = split(/\t/,$_);
    @a = map { s/^"(.*)"$/$1/; $_; } @a;
    printf "%s\n", join("\t",@a);
}

Regards,
Mit freundlichem Gruß,
    Holger Klawitter
--
Holger Klawitter                                    +49 (0)251 484 0637
holger@klawitter.de                            http://www.klawitter.de/