Changes between Version 14 and Version 15 of UsersWikiPostGIS20Ubuntu1204

Timestamp:

May 5, 2012, 11:13:09 PM (12 years ago)

Author:

jeffmeyer

Comment:

—

UsersWikiPostGIS20Ubuntu1204

@@ -196 +196 @@
 As noted above, this is a great resource: https://help.ubuntu.com/community/PostgreSQL.
 
+==== Connecting to your database using pgAdmin III====
 
 If you connect through pgadmin, use the following attributes:
@@ -214 +215 @@
 === PostGIS Extension for PostgreSQL ===
 Spatially enabling a database using extensions is a new feature of PostgreSQL 9.1.
-
+As usual, there are two methods for doing this, through psql or pgAdmin III:
+
+==== Adding extensions using psql ==== 
 Connect to a database using pgAdmin or psql, and run the following commands. For example, if you have created a database called 'GIStest', to add postgis with raster support capability to 'GIStest' do the following:
 {{{
@@ -228 +231 @@
 GIStest=#
 }}}
+
+==== Adding extensions using pgAdmin III ==== 
+
+ * Open pgAdmin III
+ * Click on the database symbol for the database to be spatially enabled
+ * Right click on the "Extensions" symbol and select "New Extension"
+ * In name, type "postgis"
+ * Then, click "OK"
+ * Repeat, using "postgis_topology"
+
 
 === Enabler Scripts / Template ===