I had a similar problem. When executing my shp2pgsql command within a bash
shell script it failed and provided me with the valid options.
Adrian Klaver, with a couple of emails back and forth, identified my error.
I had not been using single and double quotes to assign my 'command' to a
variable
On Sunday, April 24, 2011 8:01:23 pm Hyung Joo Lee wrote:
> 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 l
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".
