Re: Login information in system tables

From: Radu-Adrian Popescu <radu(dot)popescu(at)aldratech(dot)com>
To: Daniel Doorduin <Daniel(at)VanKlinkenbergSoftware(dot)nl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Login information in system tables
Date: 2004-03-08 12:49:07
Message-ID: 404C6BC3.5070100@aldratech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Henrique Alves Lima 2004-03-08 14:10:43 Simple SQL question
Previous Message Daniel Doorduin 2004-03-08 12:46:03 Login information in system tables