Home | Mirror | Search |
$ sudo -u postgres createuser -W dbuser Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) y Shall the new role be allowed to create more new roles? (y/n) n Password: $ sudo -u postgres createdb testdb -O dbuser
新建數據
CREATE DATABASE woodart WITH ENCODING='UTF8' OWNER=woodart;
CREATE DATABASE mydb ENCODING 'UTF8' TEMPLATE template0 OWNER dbuser TABLESPACE myspace;