From e4618b195ba0985d4b57b44d877624e95ad29510 Mon Sep 17 00:00:00 2001
From: Regina Obe <lr@pcorp.us>
Date: Thu, 9 May 2013 14:22:03 +0000
Subject: [PATCH] update extension install to include tiger geocoder and some
 helpful commands you can run from psql

git-svn-id: http://svn.osgeo.org/postgis/trunk@11388 b70326c6-7e19-0410-871a-916f4a2858ee
---
 doc/installation.xml | 31 +++++++++++++++++++++++++++++--
 1 file changed, 29 insertions(+), 2 deletions(-)

diff --git a/doc/installation.xml b/doc/installation.xml
index a0bea7a68..e9567b57e 100644
--- a/doc/installation.xml
+++ b/doc/installation.xml
@@ -617,7 +617,33 @@ in the <varname>extensions</varname> section of the database browser tree and wi
 
 <para>If you have the extensions available, you can install postgis extension in your database of choice by either using pgAdmin extension interface or running these sql commands:</para>
 <programlisting>CREATE EXTENSION postgis;
-CREATE EXTENSION postgis_topology;</programlisting>
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;</programlisting>
+
+<para>In psql you can use to see what versions you have installed and also what schema they are installed. </para>
+<programlisting>\connect mygisdb
+\x 
+\dx postgis*</programlisting>
+
+<screen>List of installed extensions
+-[ RECORD 1 ]-------------------------------------------------
+-
+Name        | postgis
+Version     | &last_release_version;
+Schema      | public
+Description | PostGIS geometry, geography, and raster spat..
+-[ RECORD 2 ]-------------------------------------------------
+-
+Name        | postgis_tiger_geocoder
+Version     | &last_release_version;
+Schema      | tiger
+Description | PostGIS tiger geocoder and reverse geocoder
+-[ RECORD 3 ]-------------------------------------------------
+-
+Name        | postgis_topology
+Version     | &last_release_version;
+Schema      | topology
+Description | PostGIS topology spatial types and functions</screen>
 
 <warning><para>Extension tables <varname>spatial_ref_sys</varname>, <varname>layer</varname>, <varname>topology</varname> can not be explicitly backed up.  They can only 
 be backed up when the respective <varname>postgis</varname> or <varname>postgis_topology</varname> extension is backed up, which only seems to happen when you backup the whole database. 
@@ -628,7 +654,8 @@ and assumed to be the same for a given version of an extension. These behaviors
 <para>If you installed postgis without raster support, you'll need to install raster support first (using the full <filename>rtpostgis.sql</filename></para>
 <para>Then you can run the below commands to package the functions in their respective extension.</para>
 <programlisting>CREATE EXTENSION postgis FROM unpackaged;
-CREATE EXTENSION postgis_topology FROM unpackaged;</programlisting>
+CREATE EXTENSION postgis_topology FROM unpackaged;
+CREATE EXTENSION postgis_tiger_geocoder FROM unpackaged;</programlisting>
 
 	</sect2>
 
-- 
2.50.1