Rechercher une page de manuel

Chercher une autre page de manuel:


Langue: en

Autres versions - même langue

Version: 147781 (fedora - 04/07/09)

Section: 1 (Commandes utilisateur)

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=",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
pg2xbase: DBF to PostgreSQL converter.

PostGIS: PostgreSQL with vector geometry

PostGIS: adds geographic object support to PostgreSQL.

Example: Import from PostGIS

In an existing PostGIS database, create the following table:

 id serial NOT NULL,

 mytime timestamp DEFAULT now(),

 text varchar,

 wkb_geometry geometry,


# insert value
INSERT INTO test (text, wkb_geometry)

 VALUES ('Name',geometryFromText('POLYGON((600000 200000,650000

 200000,650000 250000,600000 250000,600000 200000))',-1));

# register the table with geometry
select AddGeometryColumn ('postgis', 'test', 'geometry', -1, 'GEOMETRY', 2);
GRASS can import this PostGIS polygon map as follows: dsn="PG:host=localhost dbname=postgis user=neteler" layer=test \

         output=test type=boundary,centroid test -t test

Geometry Converters

PostGIS with shp2pgsql:
shp2pgsql -D lakespy2 lakespy2 test > lakespy2.sql
e00pg: E00 to PostGIS filter, see also
GDAL/OGR ogrinfo and ogr2ogr: GIS vector format converter and library, e.g. ArcInfo or SHAPE to PostGIS.
ogr2ogr -f "PostgreSQL" shapefile ??


db.connect, 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: 2007-11-24 13:41:10 +0100 (Sat, 24 Nov 2007) $
Help Index

15:05 1504 Comment tu sais que j'ai une voiture rouge tu es extralucide ?
15:08 15:05 : oui, je brille dans la nuit
15:09 1508 Non ca c'est translucide pas extralucide ... Ma parole qu'il
est con !