34034dcd18ca
Update
author | Steve Losh <steve@stevelosh.com> |
---|---|
date | Mon, 25 Sep 2023 21:18:31 -0400 |
parents | 34d2977b5df7 |
children | 2d292ea90902 |
branches/tags | (none) |
files | README.markdown |
Changes
--- a/README.markdown Mon Sep 25 13:37:31 2023 -0400 +++ b/README.markdown Mon Sep 25 21:18:31 2023 -0400 @@ -1046,15 +1046,14 @@ sudo -u postgres psql - postgres=# CREATE DATABASE example; - CREATE DATABASE + CREATE DATABASE example; + CREATE USER testuser WITH PASSWORD 'pass'; + GRANT ALL PRIVILEGES ON DATABASE example TO testuser; - postgres=# CREATE USER testuser WITH PASSWORD 'pass'; - CREATE ROLE + \c example + GRANT ALL ON SCHEMA public TO testuser; - postgres=# GRANT ALL PRIVILEGES ON DATABASE example TO testuser; - GRANT - - postgres=# \q + \q psql postgresql://testuser:pass@localhost:5432/example +