[postgis-users] shp2pgsql and schemas

[David Blasby]

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.

dave