From: Radu-Adrian Popescu <radu.popescu@aldratech.com>
To: Daniel Doorduin <Daniel@VanKlinkenbergSoftware.nl>
Cc: pgsql-sql@postgresql.org
Subject: Re: Login information in system tables
Date: Mon, 08 Mar 2004 14:49:07 +0200
Message-ID: <404C6BC3.5070100@aldratech.com> (raw)
In-Reply-To: <000401c4050b$5160e420$2b00a8c0@anastasia>
References: <000401c4050b$5160e420$2b00a8c0@anastasia>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: radu.popescu@aldratech.com, Daniel@VanKlinkenbergSoftware.nl
Subject: Re: Login information in system tables
In-Reply-To: <404C6BC3.5070100@aldratech.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox