Changes between Version 1 and Version 2 of UsersWikiPostgisOnUbuntu

Timestamp:

Apr 13, 2009, 2:46:43 PM (15 years ago)

Author:

pierre

Comment:

—

UsersWikiPostgisOnUbuntu

@@ -54 +54 @@
 == Using PostGIS ==
 
- 1. Create a database.  You must be the '''postgres''' superuser to do this: =
+ 1. '''Create a database.'''  You must be the '''postgres''' superuser to do this: =
  From the shell:
 
@@ -66 +66 @@
  '''REMEMBER:''' type 'exit' when you're done with these postgres commands to return to your normal user.
 
- 2. Set up the postgis libs:
+ 2. '''Set up the postgis libs:'''
 
         $ createlang plpgsql mytestdb
@@ -74 +74 @@
         $ psql -d mytestdb -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
 
- if there were no errors (if the last line of output is COMMIT), then
+  if there were no errors (if the last line of output is COMMIT), then
 
         $ psql -d mytestdb -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
 
- '''NOTE:''' Fedora 7 installed from package path is /usr/share/pgsql/contrib/
+  '''NOTE:''' Fedora 7 installed from package path is /usr/share/pgsql/contrib/
 
  2b. If you installed from source:
 
- '''NOTE:''' this looks old...
+  '''NOTE:''' this looks old...
 
         $ psql -d mytestdb -f /usr/share/postgresql/8.0/contrib/postgis-1.1.1/lwpostgis.sql
@@ -88 +88 @@
         $ psql -d mytestdb -f /usr/share/postgresql/8.0/contrib/postgis-1.1.1/spatial_ref_sys.sql
 
- 3. Make sure that your DB user has GRANT ALL on the "geometry_columns" table and GRANT SELECT on "spatial_ref_sys". =
+ 3. '''Make sure that your DB user has GRANT ALL on the "geometry_columns" table and GRANT SELECT on "spatial_ref_sys".'''
 
  '''Now import a shp file:'''
@@ -94 +94 @@
         $ shp2pgsql -D myshape.shp mytable mytestdb | psql mytestdb
 
- This will take the input file "myshape.shp" and create a new table, "mytable" in the database "mytestdb."
+  This will take the input file "myshape.shp" and create a new table, "mytable" in the database "mytestdb."
 
- To see if your shape file is there:
+  To see if your shape file is there:
 
         $ psql mytestdb