[postgis-users] using pgShapeLoader to upload csv file

[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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110808/1f57aa89/attachment.html>