SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();
But what exactly do you mean by "spatially enabled"? Any table with a
geometry column is "spatially enabled". It may not be registered with
the geometry_columns metadata table or have spatial constraints on it,
but it is capable of holding spatial data.
ie.
CREATE TEMP TABLE test (id integer, the_geom geometry);
\d
Table "pg_temp_11.test"
Column | Type | Modifiers
----------+----------+-----------
id | integer |
the_geom | geometry |
Cheers,
Kevin
Burgholzer,Robert wrote:
I have a temporary table that I would like to spatially enable. Thus, I
need to know the proper schema name, assuming that the schema name would
change if there were multiple temp tables with the same name (a
possibility if several users are hitting the app simultaneously).
Has anyone had any experience with this?
Thanks!
r/b/
Robert W. Burgholzer
Surface Water Modeler
Office of Water Supply and Planning
Virginia Department of Environmental Quality
[EMAIL PROTECTED]
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
