OK, So, what advantage is conferred by the use of the geometry_columns table?
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 David William Bitner Sent: Tuesday, August 26, 2008 9:55 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] schema name for a temp table? 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 > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- ************************************ David William Bitner
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
