grass-pg(1)

PostgreSQL driver in GRASS The driver name is 'pg'.

Creating a PostgreSQL database
A new database is created with 'createdb', see the PostgreSQL manual for details.

Connecting GRASS to PostgreSQL
# example for connecting to a PostgreSQL server:
db.connect driver=pg database="host=myserver.itc.it,dbname=mydb"
db.login user=myname pass=secret
db.connect -p
db.tables -p

Supported SQL commands
All SQL commands supported by PostgreSQL.

Operators available in conditions
All SQL operators supported by PostgreSQL.

Adding an unique ID column
Import vector module require an unique ID column which can be generated as follows in a PostgreSQL table:
echo "
 ALTER TABLE mytable ADD ID integer;
 CREATE SEQUENCE mytable_seq;
 UPDATE mytabe SET ID = nextval('mytable_seq');
 DROP SEQUENCE mytable_seq;
" | db.execute

Attribute Converters
CSV import into PostgreSQL:
\h copy
COPY t1 FROM 'filename' USING DELIMITERS ',';
pg2xbase: DBF to PostgreSQL converter.

PostGIS: PostgreSQL with vector geometry
PostGIS: add geographic object support to PostgreSQL. Geometry Converters

        PostGIS with shp2pgsql:
        shp2pgsql -D lakespy2 lakespy2 test > lakespy2.sql

        e00pg: E00 to PostGIS filter, see also v.in.e00.

        GDAL/OGR ogrinfo and ogr2ogr: GIS vector format converter and library, e.g. ArcInfo or SHAPE to PostGIS.
        ogr2ogr -f "PostgreSQL" shapefile ??

SEE ALSO
db.execute,
Database management in GRASS GIS,
Help pages for database modules,
SQL support in GRASS GIS
PostgreSQL web site,
pgAdmin graphical user interface

Book: PostgreSQL: Introduction and Concepts by Bruce Momjian
PostgreSQL Documentation
PostgreSQL Technical Documentation
GDAL/OGR PostgreSQL driver documentation
MapServer Wiki

Last changed: $Date: 2006/08/24 19:11:36 $
Help Index