[postgis-users] Postgis2.0 documentation for Windows

JamesH james.holmes at newcastle.ac.uk
Tue Apr 24 05:22:44 PDT 2012

"Is there any online or at least any useful articles and tips? I guess some
things must be the same with the linux documentation but some others, 
like uploading a raster file, cannot be the same."

Is there a specific task you're trying to acheive?

I use Postgis 2.0 on Windows and although the syntax is obviously different
from Linux, most of the content is the same. 
I find this document helpful:

For uploading a Raster, if you're PostGIS install has been successful, I run
raster2pgsql from command prompt, navigating to the folder 
raster2pgsql is in C:\Program Files..\PostgreSQL\9.1\bin

Then for most of my raster work I've used basic constraints, so something
>raster2pgsql -s YOURSRID -I -C C:\Users\dataname.tif public.tablename >
Where the constraints are from this manual:

To load it into PostGIS I opt for: In a Query Window > File > Open > the SQL
file from raster2pgsql and then Execute Query
Though for larger files it is better to use something like: psql -U
yourpostgresrole -f "C:\Users\Data\Thermal.sql" yourDatabase 

Hope that helps,


GIS Undergraduate
View this message in context: http://postgis.17.n6.nabble.com/Postgis2-0-documentation-for-Windows-tp4907743p4913285.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

More information about the postgis-users mailing list