[postgis-users] shp2pgsql and schemas

David Blasby dblasby at refractions.net
Mon Dec 15 11:43:36 PST 2003

The geometry_columns table actually looks like:

CREATE TABLE geometry_columns (
	f_table_catalog varchar(256) not null,
	f_table_schema varchar(256) not null,
	f_table_name varchar(256) not null,
	f_geometry_column varchar(256) not null,
	coord_dimension integer not null,
	srid integer not null,
	type varchar(30) not null

So just change the AddGeometryColumn() so that it matches the 
geometry_column table.

When the original AddGeometryColumn() was written there were no schema 
or catalogs in postgresql.  I used the database name for the schema.


More information about the postgis-users mailing list