pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Login information in system tables
2+ messages / 2 participants
[nested] [flat]

* Login information in system tables
@ 2004-03-08 12:46 Daniel Doorduin <Daniel@VanKlinkenbergSoftware.nl>
  2004-03-08 12:49 ` Re: Login information in system tables Radu-Adrian Popescu <radu.popescu@aldratech.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Daniel Doorduin @ 2004-03-08 12:46 UTC (permalink / raw)
  To: pgsql-sql

Hi,

I was wondering if it is possible to query the sytem tables to get an
overview of user logins in psql. I've searched the documentation but I can't
find a system table that stores login information, but I might have
overlooked something...

With regards,

Daniel Doorduin




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Login information in system tables
  2004-03-08 12:46 Login information in system tables Daniel Doorduin <Daniel@VanKlinkenbergSoftware.nl>
@ 2004-03-08 12:49 ` Radu-Adrian Popescu <radu.popescu@aldratech.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Radu-Adrian Popescu @ 2004-03-08 12:49 UTC (permalink / raw)
  To: Daniel Doorduin <Daniel@VanKlinkenbergSoftware.nl>; +Cc: 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-----





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-03-08 12:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-08 12:46 Login information in system tables Daniel Doorduin <Daniel@VanKlinkenbergSoftware.nl>
2004-03-08 12:49 ` Radu-Adrian Popescu <radu.popescu@aldratech.com>

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