Hi, the problem is here:cat infile
You need to write: cat $infile
________________________________
Απο: Kirk Wythers <[email protected]>
Προς: grass-user grass-user <[email protected]>
Στάλθηκε: 9:23 μ.μ. Παρασκευή, 4 Ιανουαρίου 2013
Θέμα: [GRASS-user] db loading error
Not exactly a grass question, but I figured you all might see what I'm doing
wrong. I am trying load a postgis db that is connected to grass.
in order to do so, I'd like to automate the 100 or so files that need to be
read into the db with a \copy process from a bash script. See below:
#!/bin/sh
for infile in /Volumes/disk7/b4warmed3/export/60min2/*.csv
do
cat infile | psql -h localhost dbname -c "\copy table1 FROM stdin with
delimiter as ',' NULL AS 'NA' CSV HEADER"
done
I'm getting an error about the name of the file I'm building to then copy from
into the db.
Does this approach require that I create the file "infile" first? And if so, in
what directory? Or does someone see some ridiculously stupid mistake I'm
making?
Here's the error:
[kirkw@truffula]bin$ ./b4warmed_loader
cat: infile: No such file or directory
Password:
cat: infile: No such file or directory
Password:
cat: infile: No such file or directory
Password:
cat: infile: No such file or directory
Password:
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
