GRASS module <-> | <--> | ODBC Interface | <--> | RDBMS |
GRASS | DBMI driver | unixODBC | ODBC driver | PostgreSQL |
Oracle | ||||
... |
[PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1
[grass6test] Description = PostgreSQL Driver = PostgreSQL Trace = No TraceFile = Database = grass6test Servername = localhost UserName = neteler Password = Port = 5432 Protocol = 8.0 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings =
To find out about your PostgreSQL protocol, run:
psql -V
db.createdb driver=odbc database=grass6test
db.connect driver=odbc database=grass6test db.copy from_driver=dbf from_database=./ from_table=mytable \ to_driver=odbc to_database=grass6test to_table=mytable
v.db.connect map=mytable.shp table=mytable key=ID \ database=grass6test driver=odbc v.db.connect -p
db.tables -p db.columns table=mytable
Doesn't work? Check with 'isql <databasename>' if the ODBC-PostgreSQL connection is really established.
v.db.connect -p mytable.shp
Last changed: $Date: 2007-07-18 07:10:27 -0700 (Wed, 18 Jul 2007) $