Re: Login information in system tables - Mailing list pgsql-sql

From Radu-Adrian Popescu
Subject Re: Login information in system tables
Date
Msg-id 404C6BC3.5070100@aldratech.com
Whole thread Raw
In response to Login information in system tables  ("Daniel Doorduin" <Daniel@VanKlinkenbergSoftware.nl>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Daniel Doorduin wrote:

| Hi,
|
| I was wondering if it is possible to query the sytem tables to get
| an overview of user logins in psql.

Check out the pg_user table.

Regards,
- --

Radu-Adrian Popescu
CSA, DBA, Developer
Aldratech Ltd.
+40213212243
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFATGvDVZmwYru5w6ERAlJ7AJ9RLaEkboJ+YNuwEcmur/OXnhlB2ACgoXum
GEy4Lun4Gtmi3FJkWFby5T8=
=4JRJ
-----END PGP SIGNATURE-----




pgsql-sql by date:

Previous
From: "Daniel Doorduin"
Date:
Subject: Login information in system tables
Next
From: Daniel Henrique Alves Lima
Date:
Subject: Simple SQL question