Hello, i've seen the question "how to remove a password" now several times in the last weeks. Attached is a small patch which add a new example for the "ALTER ROLE" documentation.
Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group
--- alter_role.sgml.orig 2007-09-03 20:46:29.000000000 +0200 +++ alter_role.sgml 2008-04-30 02:02:00.000000000 +0200 @@ -218,6 +218,14 @@ </para> <para> + Remove a role's password: + +<programlisting> +ALTER ROLE davide WITH PASSWORD NULL; +</programlisting> + </para> + + <para> Change a password expiration date, specifying that the password should expire at midday on 4th May 2015 using the time zone which is one hour ahead of <acronym>UTC</>:
-- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches