# HG changeset patch # User Steve Losh # Date 1695691111 14400 # Node ID 34034dcd18ca7aeaf7f1cd7ead12be57576701e9 # Parent 34d2977b5df7c3fbfe629c375736df6df1190aea Update diff -r 34d2977b5df7 -r 34034dcd18ca README.markdown --- 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 +