reference/sql/CREATE-GROUP.html.md.erb

---
title: CREATE GROUP
---

Defines a new database role.

## <a id="topic1__section2"></a>Synopsis

``` pre
CREATE GROUP <name> [ [WITH] <option> [ ... ] ]
```

where \<option\> can be:

``` pre
      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | CREATEUSER | NOCREATEUSER
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD '<password>'
    | VALID UNTIL '<timestamp>' 
    | IN ROLE <rolename> [, ...]
    | IN GROUP <rolename> [, ...]
    | ROLE <rolename> [, ...]
    | ADMIN <rolename> [, ...]
    | USER <rolename> [, ...]
    | SYSID <uid>
         
```

## <a id="topic1__section3"></a>Description

`CREATE GROUP` has been replaced by [CREATE ROLE](CREATE-ROLE.html), although it is still accepted for backwards compatibility.

## <a id="topic1__section4"></a>Compatibility

There is no `CREATE GROUP` statement in the SQL standard.

## <a id="topic1__section5"></a>See Also

[CREATE ROLE](CREATE-ROLE.html)