[postgis-users] using pgShapeLoader to upload csv file

2011-08-08 Thread Robert Buckley 
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

Re: [postgis-users] using pgShapeLoader to upload csv file

2011-08-08 Thread Charles Galpin 
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