docs(cli): clarify role SQL template

Nik Samokhvalov · Nik Samokhvalov · commit a43416b1e018 · 2025-12-13T11:18:40.000-08:00
- Add example ROLE_STMT expansions to cli/sql/01.role.sql
diff --git a/cli/sql/01.role.sql b/cli/sql/01.role.sql
@@ -1,4 +1,15 @@
 -- Role creation / password update (template-filled by cli/lib/init.ts)
+--
+-- Example expansions (for readability/review):
+--   create user "postgres_ai_mon" with password '...';
+--   alter user "postgres_ai_mon" with password '...';
+--   do $$ begin
+--     if not exists (select 1 from pg_catalog.pg_roles where rolname = 'postgres_ai_mon') then
+--       create user "postgres_ai_mon" with password '...';
+--     else
+--       alter user "postgres_ai_mon" with password '...';
+--     end if;
+--   end $$;
 {{ROLE_STMT}}
 
 
