X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0FB19D1D09F for ; Mon, 12 Apr 2004 20:04:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 20749-10 for ; Mon, 12 Apr 2004 20:04:35 -0300 (ADT) Received: from monty.richmond.edu (monty.richmond.edu [141.166.188.13]) by svr1.postgresql.org (Postfix) with ESMTP id F0C17D1CA80 for ; Mon, 12 Apr 2004 20:04:31 -0300 (ADT) Received: from penny.richmond.edu (penny.richmond.edu [141.166.188.34]) by monty.richmond.edu (8.11.6/8.11.6) with SMTP id i3CN4Vm02189 for ; Mon, 12 Apr 2004 19:04:31 -0400 Received: from polyester.richmond.edu ([141.166.188.14]) by penny.richmond.edu (SAVSMTP 3.1.5.43) with SMTP id M2004041219043030120 for ; Mon, 12 Apr 2004 19:04:30 -0400 Received: from richmond.edu (sfa234051.richmond.edu [141.166.234.51]) by polyester.richmond.edu (8.11.6/8.11.6) with ESMTP id i3CN4VR28088 for ; Mon, 12 Apr 2004 19:04:31 -0400 Message-ID: <407B207D.7010900@richmond.edu> Date: Mon, 12 Apr 2004 19:04:29 -0400 From: Greg Steffensen User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: password accessibility X-Enigmail-Version: 0.83.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-MailScanner: Found to be clean X-MailScanner-SpamxCheck: not spam, SpamAssassin (score=-12.1, required 5, PGP_SIGNATURE, USER_AGENT_MOZILLA_UA) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/193 X-Sequence-Number: 13166 -----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-----