# 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