Received: from masq.ingdesi.net (unknown [64.76.29.2]) by postgresql.org (Postfix) with SMTP id 34537474E4E for ; Sat, 27 Apr 2002 00:25:44 -0400 (EDT) Received: (qmail 32446 invoked by uid 502); 27 Apr 2002 04:28:55 -0000 Date: Sat, 27 Apr 2002 01:28:55 -0300 From: Eduardo Gargiulo To: pgsql-sql@postgresql.org Subject: pg_shadow password Message-ID: <20020427042855.GA32426@masq.ingdesi.net> Mail-Followup-To: pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="y0ulUmNC+osPPQO6" Content-Disposition: inline User-Agent: Mutt/1.3.28i X-Crypto: GnuPG/1.0.6 http://www.gnupg.org X-Archive-Number: 200204/342 X-Sequence-Number: 7606 --y0ulUmNC+osPPQO6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi all, this is my first message to the list. My question is how can i hide or encrypt the passwd field in pg_shadow? I remember some PASSWORD() function to do that in old versions of pgsql, but it didn't work on my db. (7.0.2) TIA --=20 Eduardo Gargiulo ejg @ ar.homelinux.org --y0ulUmNC+osPPQO6 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: see http://www2.ingdesi.net:8080/~egargiulo/gnupg.html iD8DBQE8yikHVxbsAQaGTbkRAg+pAKCwywgIVancie7HB6L3yT+JgQkLeQCgk/st jKWzGVzeUJ8AkhwyI3xIBvA= =DXOV -----END PGP SIGNATURE----- --y0ulUmNC+osPPQO6--