POSTGRESQL 安装配置
installing on linux:sudo apt-get install postgresql
where postgresql:
which psql
/usr/bin/psql
create user:
sudo -u postgres createuser myusername
create db:
createdb mydb
installing extensions:
sudo apt-get install postgresql-contrib
psql book -c "CREATE EXTENSION tablefunc"
psql book -c "CREATE EXTENSION fuzzystrmatch"
psql book -c "CREATE EXTENSION pg_trgm"
psql book -c "CREATE EXTENSION cube"
psql book -c "CREATE EXTENSION dict_xsyn"
页:
[1]