Re: [postgis-users] Reg PostGIS Shapefile Loader
Harshad Shrikhande wrote: >No record was inserted into the database as a psql exception occurred > saying 'Invalid value for a double type field'. Sounds to me like a column in the table was defined as a double and you tried inserting values of an incompatible type (maybe string or the like). Cheers, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] using pgShapeLoader to upload csv file
Assuming you can export them in a tab delimited or CSV format, you can use the "copy" command to import the data into postgresql. http://www.postgresql.org/docs/9.0/static/sql-copy.html hth charles On Aug 8, 2011, at 6:11 AM, Robert Buckley wrote: > Hi, > > What is the easiest way to load a table into posgresql? > > Usually I would just upload a shapefile into the database, but for a specific > project I am required to build a relational database system with 1 shapefile > and lots of other tables linked with Foreign Keys. > > I have never done this before for a Postgis project and was wondering on the > best way to do this. > > > The tables and shapes have been already created in an ESRI personal > geodatabase. > > thanks for any help, > > Rob > > > > > ___ > 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] using pgShapeLoader to upload csv file
Hi, What is the easiest way to load a table into posgresql? Usually I would just upload a shapefile into the database, but for a specific project I am required to build a relational database system with 1 shapefile and lots of other tables linked with Foreign Keys. I have never done this before for a Postgis project and was wondering on the best way to do this. The tables and shapes have been already created in an ESRI personal geodatabase. thanks for any help, Rob___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
