Difference between revisions of "SELECT * FROM pg roles"

From wikieduonline
Jump to navigation Jump to search
(Created page with "<pre> rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassr...")
 
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<pre>
+
SELECT * FROM [[pg_roles]];
          rolname         | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls |
+
 
                                                                                                          rolconfig
+
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls | rolconfig | oid
                                                  |   oid
+
.../...
---------------------------+----------+------------+---------------+-------------+-------------+----------------+--------------+-------------+---------------+--------------+-------------------------------
+
 
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+
== Related ==
---------------------------------------------------+---------
+
* [[CREATE USER]]
</pre>
+
* [[community]].postgresql.[[postgresql_user]]
 +
 
 +
== See also ==
 +
* {{Role}}
 +
 
 +
[[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: