34034dcd18ca

Update
[view raw] [browse files]
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
+