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

Reply via email to