[OSGeo Africa] Loading a Raster to PostGIS

Tim Sutton tim at linfiniti.com
Tue Apr 29 07:20:49 PDT 2014


On Tue, Apr 29, 2014 at 11:35 AM, Chris Smit <gis at geostratics.co.za> wrote:

>  Hi all,
> I am having difficulties with loading a DEM file to PostGIS via the
> raster2pgsql tool. Could someone shed some light on how to do this?
> Some additional information, I have used the following syntax to add the
> DEM to PostGIS:
> raster2pgsql -s 2048 -f rast -I -C -Y C:\Users\GIS\Desktop\Project\DEM.tif > DEM.sql
> psql -h localhost -U postgres -d Topography -f DEM.sql
> After running the above syntax in the command line, I receive "COMMIT".
> This creates a new table in the default Public schema (have tried to add it
> to another schema using the *someschema.sometable* syntax, but this
> returns an error stating the schema does not exist). In PostGIS, the table
> is created but does not seem to contain information. Also, I am unable to
> open or view the DEM in QGIS.

Have you checked if the raster support has been installed? Check if the
raster_columns table exists in the public schema...



> Thanks in advance
> Chris
> _______________________________________________
> Africa mailing list
> Africa at lists.osgeo.org
> You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa

Tim Sutton

Visit http://linfiniti.com to find out about:
 * QGIS programming services
 * GeoDjango web development
 * QGIS Training
 * FOSS Consulting Services
Skype: timlinux Irc: timlinux on #qgis at freenode.net
Tim is a member of the QGIS Project Steering Committee
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20140429/81c55d24/attachment.html>

More information about the Africa mailing list