The first action you should do is entering into psql mode as
Code Block |
---|
sudo -u postgres psql |
Below is a common script can create a database in PostgreSQLpsql
Code Block |
---|
sudo -u postgres psql
update pg_database set datallowconn = TRUE where datname = 'template0';
\c template0
update pg_database set datistemplate = FALSE where datname = 'template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';
update pg_database set datistemplate = TRUE where datname = 'template1';
\c template1
update pg_database set datallowconn = FALSE where datname = 'template0';
create database mydb with encoding='utf8' template=template0;
create user myuser with encrypted password 'mypass';
grant all privileges on database mydb to myuser; |
...