I think what Randy was suggesting was to make a create a temporary database 
table using shp2pgsql, then copy over just the geometries into the actual table 
you want them stored in using SQL. An alternative to this would be to just use 
a perl script to strip out all of the extra attribute columns from the output 
of shp2pgsql. Basically just depends on whether you'd rather use SQL or shell 
script to solve the problem.

Chris

Quoting Matt Lynch <matt@terraEngine.com>:

> Hi Randy,
> 
> I have been a little skimpy on describing what I am doing, so here goes.
> 
> I have an application which will allow users access to shape and raster
> data for a defined region.  The region is specified by a polygon.
> 
> I am now writing a web app to handle the administration side.  In the
> web app I allow administrators to upload shape files which then are
> loaded into a table.  My problem is that I don't want to trust the
> administrators to not include attributes in the shape file.  I
> anticipate the temptation to use existing shape files will be too great.
> So I would like to somehow extract only the polygon.
> 
> Thanks,
> 
> Matt
> 
> 
> 
> -----Original Message-----
> From: postgis-users-bounces@postgis.refractions.net
> [mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of
> Randy James
> Sent: Monday, September 22, 2003 11:18 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Loading only polygon with shp2pgsql
> 
> 
> Hi
> 
> I would make your polygons a file without any attributes in
> its table and than use join to attach your attributes from another
> table. But i'm not sure if thats what you are looking for.
> 
> Cheers
> Randy
> 
> --- Matt Lynch <matt@terraEngine.com> wrote:
> > Hi,
> >
> > I am wondering if there is a way for me to load the
> > polygon information
> > from a shape file only (i.e. without attribute data)?
> >
> > I am currently using shp2pgsql with -a to append to a
> > table, but want to
> > avoid problems if I append a shape file with a new
> > attribute associated.
> >
> > Thanks,
> >
> > Matt
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system
> > (http://www.grisoft.com).
> > Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list postgis-users@postgis.refractions.net
> >
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> 
> _______________________________________________
> postgis-users mailing list postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 





