[postgis-users] schema support patch 5 (shp2pgsql)

strk strk at keybit.net
Tue Feb 3 00:48:06 PST 2004


I've patched shp2pgsql to explicitly support a schema.

You can use <schema>.<table> to be explicit
or just <table> to rely on the pg's search_path at feed time
or to use with pre-schema PG versions.

MixeD Case Names are Supported (MySchema.MyTable) with both
forget-identifiers-case (no option) and keep-identifiers-case (-k)
logics.

WARNINGS:
	- You cannot use a schema containing a dot in the name
	  ( "My.Schema"."My.Table" is not supported )

	- The schema you specify must already exist
	  ( No create schema is issued )

Comments welcome,
--strk;



More information about the postgis-users mailing list