--- 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
+