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
