Page Comparison

function create_db() { createdb $1 -U postgres; };
function drop_db() { dropdb $1 -U postgres; };
function open_db() { psql -U postgres $@;};
function dump_db() { pg_dump -U postgres $1 -O > $1$2.sql; };
function update_db() {
	MES_VERSION=`ls -1 ${qcadoosrc}/mes-commercial/sql/ | sort -gr | head -1`
	SCHEMA_VERSION=`ls -1 ${qcadoosrc}/mes-commercial/sql/$MES_VERSION/ | sort -gr | head -1`

    psql -U postgres $1 -f ${qcadoosrc}/mes-commercial/sql/$MES_VERSION/$SCHEMA_VERSION/bulk$SCHEMA_VERSION.sql
}

alias create_db='create_db'
alias drop_db='drop_db'
alias open_db='open_db'
alias dump_db='dump_db'
alias update_db='update_db'

alias show_db='psql -U postgres -l'