[GRASS-dev] PostGreSQL functionality in GRASS.

[Moritz Lennert]

On 23/04/09 06:19, kavitesh.singh at wipro.com wrote:
> Hi All,
> 
>  
> 
> It is a novice question, I want to know how is the PostGreSQL used in 
> GRASS. My initial thought was that it stores the map attributes and 
> spatial information in PostGreSQL or similar databases. On the other 
> hand I also feel the dataset which GRASS uses to store map information 
> (raster/vector) has all the spatial information. I can use a dataset and 
> use in on any other system installation without copying anything from 
> database.

GRASS stores the geometries (i.e. the "spatial" information) internally 
with an identifier (called category). You can then link these geometries 
to attributes which can be stored in any of the supported DB backends, 
i.e. DBF files, SQLite, PostgreSQL, MySQL or any database accessible via 
ODBC.

Please read http://grass.itc.it/grass63/manuals/html63_user/vectorintro.html
and
http://grass.itc.it/grass63/manuals/html63_user/sql.html

Moritz