cacher-rui
9/15/2013 - 12:21 AM

List all roles in postgres. From http://www.opengurukul.com/vlc/mod/page/view.php?id=3121

List all roles in postgres. From http://www.opengurukul.com/vlc/mod/page/view.php?id=3121

new_gist_file
content_copyfile_download
postgres=# SELECT rolname FROM pg_roles;
+----------+
| rolname  |
+----------+
| postgres |
| matsya1  |
+----------+
(2 rows)
 
postgres=#