[postgis-users] schema name for a temp table?

[Kevin Neufeld]

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
> 
> rwburgholzer at deq.virginia.gov
> 
> 804-698-4405
> 
> Open Source Modeling Tools:
> 
> http://sourceforge.net/projects/npsource/
> 
>  
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users