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

Tue Aug 26 10:30:15 PDT 2008

Thanks David, this is good info!

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: david.bitner at gmail.com [mailto:david.bitner at gmail.com] On Behalf
Of David William Bitner
Sent: Tuesday, August 26, 2008 1:29 PM
To: Burgholzer,Robert
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] schema name for a temp table?

Interoperability and standards.  The geometry_columns table provides
metadata that is required for standards compliance and used by many
client programs.  Internally, it does nothing.  The other thing that
AddGeometryColumn() does that is valuable is to create constraints on
the geometry column to make sure that all records are of the same
geometry type and in the same srid.

On Tue, Aug 26, 2008 at 12:25 PM, Burgholzer,Robert
<rwburgholzer at deq.virginia.gov> wrote:

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

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

-- 
************************************
David William Bitner

-- 
************************************
David William Bitner

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080826/569e68aa/attachment.html>