From d83d800336438ef65ea66433b2123a8e96d4fe34 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Tue, 13 Dec 2011 21:58:41 +0000 Subject: [PATCH] more examples -- put in a missing copy switch -- more switches to add. git-svn-id: http://svn.osgeo.org/postgis/trunk@8394 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/using_raster_dataman.xml | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/doc/using_raster_dataman.xml b/doc/using_raster_dataman.xml index c35f4c8d9..5594188c2 100644 --- a/doc/using_raster_dataman.xml +++ b/doc/using_raster_dataman.xml @@ -178,6 +178,14 @@ + + -Y + + + Use copy statements instead of insert statements. + + + @@ -205,6 +213,10 @@ psql -d gisdb -f elev.sql A conversion and upload can be done all in one step using UNIX pipes: raster2pgsql -s 4236 -I -C -M *.tif -F -t myschema.demelevation | psql -d gisdb + + Load rasters Massachusetts state plane feet aerial tiles + into a schema called aerial and create a full view, 2 and 4 level overview tables and directly insert to database. Break up the rasters into 100x100 pixel tiles and apply raster constraints + raster2pgsql -I -C -s 26986 -t 100x100 bostonaerials2008\*.jpg -l 2,4 aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432 -- 2.40.0