PostGIS Cookbook - Second Edition

Getting ready

1. Create the proxy script and deploy it to your web server (that is, HTTPD or IIS), as indicated in the Getting ready section of the Consuming WMS services with OpenLayers recipe.
2. Create the following PostGIS points layer named sites:

        CREATE TABLE chp09.sites 
        ( 
          gid serial NOT NULL, 
          the_geom geometry(Point,4326), 
          CONSTRAINT sites_pkey PRIMARY KEY (gid ) 
        ); 
        CREATE INDEX sites_the_geom_gist ON chp09.sites 
        USING gist (the_geom ); 

3. Now create a PostGIS layer in GeoServer for the chp09.sites table. For more information on this, refer to the Creating WMS and WFS services with GeoServer recipe in this chapter.