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
[EMAIL PROTECTED] http://www.klawitter.de/
