Markus Neteler
5e2bc274f1
fixed unlucky formatted messages (thanks to Glynn)
|
16 years ago | |
|---|---|---|
| .. | ||
| Makefile | 17 years ago | |
| README | 17 years ago | |
| create_table.c | 16 years ago | |
| cursor.c | 16 years ago | |
| db.c | 16 years ago | |
| dbdriver.h | 16 years ago | |
| describe.c | 16 years ago | |
| driver.c | 16 years ago | |
| error.c | 16 years ago | |
| execute.c | 16 years ago | |
| fetch.c | 16 years ago | |
| globals.h | 16 years ago | |
| grass-pg.html | 16 years ago | |
| index.c | 16 years ago | |
| listdb.c | 16 years ago | |
| listtab.c | 16 years ago | |
| main.c | 16 years ago | |
| parse.c | 16 years ago | |
| priv.c | 16 years ago | |
| proto.h | 16 years ago | |
| select.c | 16 years ago | |
README
Postgres driver.
This driver was originaly written by Alex Shevlakov using dbf driver
(PostgreSQL driver forked from DBF driver by Radim Blazek).
DBF driver was not good starting point, so I (R. Blazek) have rewritten it again
using ODBC, postgres driver and adding new code.
Driver supports only some field types, other types are ignored and warning is printed
by G_warning().
FIELD TYPES:
Field type code may change. See for example
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/pg_type.h
Because of this, type codes must be read from server when database is opened.
Check also for PostgreSQL data types for defining them in GRASS:
/usr/include/pgsql/server/catalog/pg_type.h
Supported types in ./globals.h:
(http://www.postgresql.org/docs/8.2/interactive/datatype.html)
DB_C_TYPE_INT:
bit, int2, smallint, int4, int, integer, int8, bigint, serial, oid
DB_C_TYPE_DOUBLE:
float4, real, float8, double precision, numeric, decimal
DB_C_TYPE_STRING:
character, char, character varying, varchar, text, bool, boolean
DB_C_TYPE_DATETIME:
date, time, timestamp
This driver was originaly written by Alex Shevlakov using dbf driver
(PostgreSQL driver forked from DBF driver by Radim Blazek).
DBF driver was not good starting point, so I (R. Blazek) have rewritten it again
using ODBC, postgres driver and adding new code.
Driver supports only some field types, other types are ignored and warning is printed
by G_warning().
FIELD TYPES:
Field type code may change. See for example
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/include/catalog/pg_type.h
Because of this, type codes must be read from server when database is opened.
Check also for PostgreSQL data types for defining them in GRASS:
/usr/include/pgsql/server/catalog/pg_type.h
Supported types in ./globals.h:
(http://www.postgresql.org/docs/8.2/interactive/datatype.html)
DB_C_TYPE_INT:
bit, int2, smallint, int4, int, integer, int8, bigint, serial, oid
DB_C_TYPE_DOUBLE:
float4, real, float8, double precision, numeric, decimal
DB_C_TYPE_STRING:
character, char, character varying, varchar, text, bool, boolean
DB_C_TYPE_DATETIME:
date, time, timestamp