sudo su
apt-get install postgresql-9.1-postgis
#super user pro postgresql
su postgres
#vytvoreni uzivatele
createuser -s -P ruz76
#vytvoreni databaze
createdb ruz76

#aktivovani exktenze posgis pro vasi databazi -d nazevdatabaze
psql -d ruz76 -c "CREATE EXTENSION postgis;"
psql -d ruz76 -c "CREATE EXTENSION postgis_topology;"

#exit z postgres user 
exit
#exit z root user 
exit

#export SHP do SQL
shp2pgsql -W LATIN2 kraje_pseudo.shp kraje_pseudo > kraje_pseudo.shp.sql
#import SQL do databaze
psql -f kraje_pseudo.shp.sql -h localhost -U ruz76 -W ruz76

#gui klienti pro import dat do postgis
QGIS, shp2pgsql-gui, OpenJUMP, uDIG

#overeni ze to funguje
psql -h localhost -U ruz76 -W ruz76
\d
q
SELECT nazkr FROM kraje_pseudo;