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

[Burgholzer,Robert]

Kevin,
Thanks for the response.  By spatially enabled, I mean, has a geometry
column, and I wish to use that column for comparison operators, such as
st_within().  Furthermore, since I am adding the column to a table of
data, then setting the geom column to table lat/lon values, I needed to
use addgeometrycolumn (at least I think that I need to do that).

Anyhow, your query gives me just the information that I need.  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/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Kevin Neufeld
Sent: Monday, August 25, 2008 5:51 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] schema name for a temp table?

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users