pipe line error (psql command)

From: Hyung Joo Lee <procarrie(at)imrc(dot)kist(dot)re(dot)kr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pipe line error (psql command)
Date: 2011-04-25 03:01:23
Message-ID: 3E94D039A2B82544B3E7D48F924B0B25E12229165E@base.imrc.kist.re.kr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

I got some error about psql pipeline.

I input the command in shell script below :

"shp2pgsql -d -w -I -s 987987(custom srid) test.shp test | psql -h testhost -d testdb"

The problem is, when I check the table list and geometry_columns table, that it doesn't have schema_name "public".

It's like "select AddGeometryColumn('','test','the_geom',987987,'MULTIPOLYGON',2);"

There's no 'public'...

Before "|", it doesn't have an error. I confirmed the output messege by using "echo".

If I copy the command before "|" like "shp2pgsql -d -w -I -s 987987 test.shp test", and then typing by keyboard the "| psql -h testhost -d testdb"

It is working well including 'public'. It's occurred error only after executing shell script like $./test.sh

How can I do? What should I change or something to do?

Thanks in advanced.

Kevin Lee.
Best Regards.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message LeeHyung Joo - Kevin 2011-04-25 03:05:28
Previous Message John R Pierce 2011-04-25 00:40:22 Re: Need to replace SAN, best method with least downtime? (8.4.4)