Nope, you don't have to use addgeometrycolumn at all. You just need to create a table with a column declared as geometry.
Create table foo (my_geom_column geometry, my_id serial, my_attribute varchar); On Tue, Aug 26, 2008 at 8:20 AM, Burgholzer,Robert < [EMAIL PROTECTED]> wrote: > 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 > [EMAIL PROTECTED] > 804-698-4405 > Open Source Modeling Tools: > http://sourceforge.net/projects/npsource/ > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 > > > > [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 > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- ************************************ David William Bitner
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
