Differences

This shows you the differences between two versions of the page.

--- quickref:postgres [2025-11-07 Fri 19:02] – add constraint add/drop theorytoe
+++ quickref:postgres [2025-12-23 Tue 20:38] (current) – [Create Role & DB] rolename missing theorytoe
@@ Line 7: / Line 7: @@
 CREATE DATABASE <dbname>;
 CREATE ROLE <rolename>;
-ALTER USER backend WITH PASSWORD '<password>';
+ALTER USER <rolename> WITH PASSWORD '<password>';
-ALTER USER backend WITH LOGIN;
+ALTER USER <rolename> WITH LOGIN;
 ALTER DATABASE <dbname> OWNER TO <rolename>;
 GRANT ALL PRIVILEGES ON DATABASE <dbname> TO <rolename>;

kyaruc memex