Diferencia entre revisiones de «Usuario:Lmorillas/postgresql»
De WikiEducator
| Línea 10: | Línea 10: | ||
/password | /password | ||
| − | |||
| − | |||
}} | }} | ||
Revisión de 21:09 27 nov 2012
sudo apt-get install postgresql pgadmin3 sudo -u postgres psql /password
|
sudo -u postgres createuser myusername Shall the new role be a superuser? (y/n) y createdb book
psql book -c "CREATE EXTENSION tablefunc" ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/tablefunc.control": No such file or directory
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"
