Raymond Raymond / Code Snippets & Tips

PostgreSQL: Create and List User

event 2021-09-24 visibility 577 comment 0 insights toc
insights Stats
toc Table of contents

PostgreSQL is one of the popular open source relational SQL databases. If you don't have a PostgreSQL databases, you can configure one on your Windows Subsystem for Linux easily: Install PostgreSQL on WSL. The steps to install it on UNIX-alike systems are similar.

Create user

The following code snippets shows you how to create a database user.

Create user without password:

CREATE USER kontext;

Drop user:

drop user kontext;

Create user with password:

CREATE USER kontext WITH PASSWORD 'kontext';

Create user with password and also expiry date:

CREATE USER kontext WITH PASSWORD 'kontext' VALID UNTIL '2021-12-01';

Create user with password and roles:


The above statement creates a user with two default roles: create database and create role.

Show or list users


Example output:

postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of
 kontext   | Create role, Create DB                                    +| {}
           | Password valid until 2021-12-01 00:00:00+11                |
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts