Changes between Version 101 and Version 102 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
09/18/10 13:30:30 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v101 v102  
    266266
    267267== PostgreSQL management ==
    268  * Connect to Database (or use pgAdmin III GUI's PSQL Console on plugins menu)
    269 {{{
    270 su postgres
    271 psql
    272 }}}
    273 or
    274 {{{
    275 psql -d my_spatial_db -U username
    276 }}}
    277  * List Databases
    278 {{{
    279 \l
    280 }}}
    281  * List Tables
    282 {{{
    283 \d
    284 }}}
    285  * List Table structure
    286 {{{
    287 \d tablename
    288 select field/* from tablename where field = 'value';
    289 }}}
    290 
    291268=== PostGIS functions ===
    292269 * Centroids