[OSGeo Africa] Importing Data into Postgresql

[Tim Sutton]

Hi

In addition to the other replies given to this thread you can also try:

- use the 'SPIT' plugin in QGIS to bring your data into PostgreSQL
- use the command line e.g.

shp2pgsql -s 4326 -t tdwg_world_boundaries level4.dbf | psql gis

However the second option above may not work well on windows where they
only give you a broken cmd.exe shell environment.

If you and others need more help, I'd be happy to run a 'bring your own
machine' type workshop focussed on getting to grips with PostGIS a bit
more and helping you to load all your own data.

PostGIS really is the core of any FOSS based spatial data infrastructure
and is well worth getting to grips with.


Regards

Tim


On Thu, 2008-12-11 at 03:30 -0800, losso ekolo wrote:
> Hi,
>      Good day. I can't import data into Postgresql after many
> attempts.
> I'm sure i'm missing something. I tried to follow the steps on wiki
> AfricaEvents29November2008 but to no avail.
> I'm using Windows Xp. 
> 
> Regards,
> 
> Losso
>  
> PS: I'm missed the first part of the Workshop.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> ______________________________________________________________________
> Get your new Email address! 
> Grab the Email name you've always wanted before someone else does!
> _______________________________________________
> Africa mailing list
> Africa at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/africa

-- 
Tim Sutton - QGIS Project Steering Committee Member (Release  Manager)
==============================================
Visit http://linfiniti.com to find out about:
 * QGIS programming services
 * Mapserver and PostGIS based hosting plans
 * FOSS Consulting & Support Services
Skype: timlinux Irc: timlinux on #qgis at freenode.net
==============================================
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://lists.osgeo.org/pipermail/africa/attachments/20081213/be6fe2f5/attachment.bin