Re: imorting csv files into postgres

mike wrote:

> Does anyone know if you can import csv text files into postgres

A perl script to do that was just posted to the GENERAL List....
Hmmmm....

Tim Uckun just posted the following:
-------
Here is your steps. 1) Create your destination table in postgres
2)  Export your data to a comma delimeted format
3)  save this perl script to a file

------
#! /usr/bin/perl
$inquotes = 0;
while (<>){    # Chop the crlf    chop ($_);    chop ($_);
    # this first bit goes through and replaces    # all the commas that re not in  quotes with tildes    for ($i=0 ; $i
<length($_) ; $i++){        $char=substr($_,$i,1);        if ($char eq '"' ){            $inquotes = not($inquotes);
   }else{            if ( (!$inquotes) && ($char eq ",") ){                substr($_,$i,1)="~";            }        }
}    # this replaces any quotes    s/"//g;    print "$_\n";
 
}
-----

4) type this cat myfile.txt | perl myprog.pl > outfile.dat
5) go to psql
6) COPY "tablename" FROM '/path/to/outfile.dat' USING DELIMITERS '~';
-----

See if that helps any.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11