13 linhas
615 B
Plaintext
13 linhas
615 B
Plaintext
# Create DB
|
|
|
|
Create User
|
|
$ podman exec -it postgres psql -U postgres -c "CREATE USER [nome_progetto] WITH password '[password_db_progetto]';"
|
|
|
|
Or with CREATEDB
|
|
$ podman exec -it postgres psql -U postgres -c "CREATE USER [nome_progetto] WITH password '[password_db_progetto]' CREATEDB;"
|
|
|
|
Create DB
|
|
$ podman exec -it postgres psql -U postgres -c "CREATE DATABASE [nome_progetto];"
|
|
$ podman exec -it postgres psql -U postgres -c "GRANT ALL privileges ON DATABASE [nome_progetto] TO [nome_progetto];"
|
|
$ podman exec -it postgres psql -U postgres -d [nome_progetto] -c "GRANT CREATE ON SCHEMA public TO [nome_progetto];"
|