For example shp2pgsql myGeoms.shp | more
produce a SQL script that creates and inserts values into a public.MagicName
table. I need to preserve MagicName
and change only public
to mySchema
... Is it possible?
the
-h
summary say to use something asshp2pgsql myGeoms.shp mySchema.
but it producesCREATE TABLE "mySchema".""
that is wrong ... And seems an "interface bug", because is a valid parameter but produces invalid output.this question is not about
mySchena.myTableName
.