Difference between revisions of "SELECT * FROM pg roles"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
  SELECT * FROM [[pg_roles]];
 
  SELECT * FROM [[pg_roles]];
  
<pre>
+
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls | rolconfig | oid
          rolname         | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls |
+
.../...
                                                                                                          rolconfig
 
                                                  |   oid
 
---------------------------+----------+------------+---------------+-------------+-------------+----------------+--------------+-------------+---------------+--------------+-------------------------------
 
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
---------------------------------------------------+---------
 
</pre>
 
  
 +
== Related ==
 +
* [[CREATE USER]]
 +
* [[community]].postgresql.[[postgresql_user]]
  
 
== See also ==
 
== See also ==
 
* {{Role}}
 
* {{Role}}
* {{PostgreSQL}}
 
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 18:39, 14 December 2022

SELECT * FROM pg_roles;
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls | rolconfig | oid
.../...

Related[edit]

See also[edit]

Advertising: