CREATE_USER(7pg18)

💖 CREATE USER 💖 (that's CREATE_USER(7), from the PostgreSQL 18.6 Documentation bestie, we're literally in the big book)

okay so. bestie. sit down. we're making a whole new database role and honestly it's giving main character energy from the very first line. this is the CREATE USER page, and yes it's under manual name CREATE USER, and yes i'm obsessed. let's go 🫶

---

✨ NAME ✨

CREATE_USER — define a new database role 💅

---

🌸 SYNOPSIS 🌸

CREATE USER name [ [ WITH ] option [ ... ] ]

and like, option can be any of these iconic little guys:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT connlimit
    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
    | VALID UNTIL 'timestamp'
    | IN ROLE role_name [, ...]
    | IN GROUP role_name [, ...]
    | ROLE role_name [, ...]
    | ADMIN role_name [, ...]
    | USER role_name [, ...]
    | SYSID uid

---

🦋 DESCRIPTION 🦋

okay so the tea ☕: CREATE USER is now an alias for CREATE ROLE. that's it. that's the whole plot twist.

the one and only difference, and this is the part you cannot miss because it's literally the entire reason this page exists:

• when you spell it CREATE USER — LOGIN is assumed by default 🌈
• when you spell it CREATE ROLE — NOLOGIN is assumed 🌙

that's it bestie. same energy, different defaults. iykyk 💅

---

💀 COMPATIBILITY 💀

so. the CREATE USER statement is a PostgreSQL extension. the SQL standard literally just... leaves the definition of users to the implementation. not the standard's problem. not our problem. we're just built different fr fr 😭

---

👑 SEE ALSO 👑

• CREATE ROLE (CREATE_ROLE(7)) — go read it, it's the whole vibe underneath this one 🎀

---

and that's the page, bestie!! every flag, every default, every extension note, all of it, preserved like a little pressed flower 🌸 stay logged in, stay iconic, and remember: CREATE USER = CREATE ROLE but with LOGIN on by default. periodt. 💅✨

signed off with love from the PostgreSQL 18.6 docs, dated 2026, page CREATE USER(7) — you're welcome, mwah 🫶💖