fastread homefastrread library fastread menu

PostgreSQL : Find Users in PostgreSQL

Tutorial by:      Date: 2016-04-19 23:30:59

❰ Previous Next ❱

Question:Is there a query to run in PostgreSQL that will return all Users created?

Answer: In PostgreSQL, there is a system table called pg_user. You can run a query against this system table that returns all of the Users that have been created in PostgreSQL as well as information about these Users.

To retrieve all Users in PostgreSQL, you can execute the following SQL statement:

SELECT usename

FROM pg_user;

The pg_user table contains the following columns:

Column

Explanation

usename

User name (ie: postgres, fastread.aitechtonic, etc)

usesysid

User ID (number assigned by PostgreSQL)

usecreatedb

Boolean value indicating whether user can create databases (t or f)

usesuper

Boolean value indicating whether user is a superuser (t or f)

usecatupd

Boolean value indicating whether user can update system catalogs (t or f)

userepl

Boolean value indicating whether user can initiate replication (t or f)

passwd

Password for user displayed as ********

valuntil

Time when password will expire

useconfig

Session defaults for run-time configuration variables

 

❰ Previous Next ❱


PostgreSQL

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website