[GRASSweb-list]markus: web/grass51/tutorial attrib_storage.html,1.4,1.5
grass at intevation.de
grass at intevation.de
Wed Jan 15 13:01:38 EST 2003
Author: markus
Update of /grassrepository/web/grass51/tutorial
In directory doto:/tmp/cvs-serv9733
Modified Files:
attrib_storage.html
Log Message:
finished PostgreSQL for now
Index: attrib_storage.html
===================================================================
RCS file: /grassrepository/web/grass51/tutorial/attrib_storage.html,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- attrib_storage.html 15 Jan 2003 17:04:19 -0000 1.4
+++ attrib_storage.html 15 Jan 2003 18:01:36 -0000 1.5
@@ -284,6 +284,7 @@
<li> Next add an entry in the GRASS 5.1 'DB' file:
<div class="code"><pre>
+# map field table ID database DBMIdriver
markveggy.shp 1 markveggy VEGCNP_ID grass51test odbc
</div></pre>
@@ -331,22 +332,27 @@
Now store the table into PostgreSQL (you may use pg.in.dbf from 5.0 or other
tools).
<p>
+Let's assume that PostgreSQL runs on machine 'pgserver'.
Add entry in the GRASS 5.1 'DB' file in the mapset directory:
<div class="code"><pre>
-markveggy.shp 1 markveggy VEGCNP_ID grass51test pg
+# map field table ID database DBMIdriver
+markveggy.shp 1 markveggy VEGCNP_ID host=pgserver,dbname=grass51test,user=neteler pg
</div></pre>
-Connect GRASS 5.1 to the table (on machine 'pgserver' runs PostgreSQL):
+Connect GRASS 5.1 to the table:
<div class="code"><pre>
db.connect driver=pg database="host=pgserver,dbname=grass51test,user=neteler"
db.tables -p
db.describe -c markveggy
</div></pre>
-If a password is required, a dialog will ask you (or you supply
-'password=secretword').
-This should print name and columns of the table 'markveggy' which is stored
-as PostgreSQL table.
+If, depending on the definition of the database 'grass51test' a password is
+required, a pop-up dialog window will ask you (alternatively you could supply
+',password=secretword' in DB file and db.connect line, which is not
+recommended for security reasons).
+
+This should connect the map to the table. db.describe will print table name and
+columns of the table 'markveggy' which is stored as PostgreSQL table.
<P>
Doesn't work? Check with 'psql -l' if the PostgreSQL
More information about the grass-web
mailing list