[GRASS-user] db loading error

[Nikos Alexandris]

Hi Kirk!

I think it's just a bash-syntax error. Try

for SomeVariable in WhatEver; do

-------------------------------------------^^^

notice the  " ;  "


Best, Nikos

Kirk Wythers wrote:

> 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:

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 230 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20130105/f0ed62ee/attachment.pgp>