password accessibility

[Greg Steffensen]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm in the process of integrating a jabber server into a
postgresql-based web portal. The portal has a separate postgresql
user for every registered user of the site. Authentication on the
site is easy enough; the site just attempts to connect to the db using
the provided credentials, and if its successful, the user is logged
in. The jabber server needs the passwords (or their md5 hashes)
visible in standard table format for authentication, though. I'd like
to construct a view containing the usernames, passwords, etc in
jabber's required format, but system catalog information doesn't seem
to be accessible to views. Is there any way to pull the information
from the pg_shadow catalog into a view?

Greg Steffensen
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3-nr1 (Windows XP)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAeyB9Gt2K2bwjlc0RAj7QAJ9SfEYykhH5YvMqGZJopXouaSFz5QCfZWD7
XvSmm9Tik6Jt/Di762T72So=
=XD4x
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Peter Eisentraut]

I'd like to construct a view containing the usernames, passwords, etc
in jabber's required format, but system catalog information doesn't
seem to be accessible to views.

That is not correct.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match