[postgis-users] shp2pgsql and schemas

[Seamus Thomas Carroll]

Hi,

I have used shp2pgsql in a version released sometime before the summer and
there used to be an arguement for the schema and the table.

shp2pgsql for 0.8.0 does not have this option.  I thought I could just
input both piece of information in the table arguement ( schema.table )
but this results in the error when loading the file using psql:
NOTICE:  CREATE TABLE will create implicit sequence "carrolls_route_alberta_test_gid_seq" for "serial" column "carrolls_route_alberta_test.gid"
psql:toload.sql:1: NOTICE:  CREATE TABLE will create implicit sequence "carrolls_route_alberta_test_gid_seq" for "serial" column "carrolls_route_alberta_test.gid"
CREATE TABLE
ERROR:  relation "roads.carrolls_route_alberta_test" does not exist
CONTEXT:  PL/pgSQL function "addgeometrycolumn" line 38 at execute statement
psql:toload.sql:2: ERROR:  relation "roads.carrolls_route_alberta_test" does not exist
CONTEXT:  PL/pgSQL function "addgeometrycolumn" line 38 at execute statement
BEGIN
ERROR:  column "the_geom" of relation "carrolls_route_alberta_test" does not exist
psql:toload.sql:4: ERROR:  column "the_geom" of relation "carrolls_route_alberta_test" does not exist
ERROR:  current transaction is aborted, commands ignored until end of transaction block
....
and so on.

What is the new technique for loading gis data into a schema other than
public?

Seamus