From 00dd340210ed67900e03703eb088fdd5ab12c099 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 31 Jan 2011 22:53:58 -0500 Subject: [PATCH] Improve docs for pg_authid encryption description with better markup and a mention of unencrypted passwords. --- doc/src/sgml/catalogs.sgml | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index ecedaccaf7..09152e6c5c 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1264,12 +1264,14 @@ rolpassword text - Password (possibly encrypted); null if none. If the password is - encrypted, this column will contain the string md5 followed by a - 32-character hexadecimal MD5 hash. The MD5 hash will be of the - user's password concatenated to their username (for example, if - user joe has password xyzzy, PostgreSQL will store - the md5 hash of xyzzyjoe). + Password (possibly encrypted); null if none. If the password + is encrypted, this column will begin with the string md5 + followed by a 32-character hexadecimal MD5 hash. The MD5 hash + will be of the user's password concatenated to their username. + For example, if user joe has password xyzzy, + PostgreSQL will store the md5 hash of + xyzzyjoe. A password that does not follow that + format is assumed to be unencrypted. -- 2.40.0