[GRASS-user] Σχετ: db loading error

[Leonidas Liakos]

Hi, the problem is here:cat infile
You need to write: cat $infile


________________________________
 Απο: Kirk Wythers <kirk.wythers at gmail.com>
Προς: grass-user grass-user <grass-user at lists.osgeo.org> 
Στάλθηκε: 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 at 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
grass-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20130105/80a21e6f/attachment.html>