PostgreSQL Notes:

To create database:

/opt/local/lib/pgsql8/bin/createdb -U postgres omardb
/opt/local/lib/pgsql8/bin/createlang -U postgres -d omardb plpgsql

To install postgis:

/opt/local/lib/pgsql8/bin/psql -U postgres -d omardb -f /opt/local/share/postgis/lwpostgis.sql
/opt/local/lib/pgsql8/bin/psql -U postgres -d omardb -f /opt/local/share/postgis/spatial_ref_sys.sql

To runt the sql cmdln client:

/opt/local/lib/pgsql8/bin/psql -U postgres -d omardb

To destroy database:

/opt/local/lib/pgsql8/bin/dropdb -U postgres omardb