Changes between Version 9 and Version 10 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
09/18/10 13:29:26 (14 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • InstallationGuidelines/PostgreSQL

    v9 v10  
    5252
    5353== Maintenance ==
     54Connect to Database (or use pgAdmin III GUI's PSQL Console on plugins menu):
     55{{{
     56su postgres
     57psql
     58}}}
     59or
     60{{{
     61psql -d my_spatial_db -U username
     62}}}
     63
     64List Databases:
     65{{{
     66\l
     67}}}
     68
     69List Tables:
     70{{{
     71\d
     72}}}
     73
     74List Table structure:
     75{{{
     76\d tablename
     77select field/* from tablename where field = 'value';
     78}}}
     79
    5480If you need to build a fresh database:
    5581{{{