alban wrote:
> How remove a password validity ?
>
>
> CREATE USSER xxxxx WITH VALID UNTIL 'uuuuuu'
> ALTER USSER xxxxx WITH VALID UNTIL 'uuuuuu'
> but how remove password valid until ?
I think you have to specify the data as 'infinity'.
test=> CREATE USER xxxxx WITH VALID UNTIL '2005-01-01';
CREATE USER
test=> ALTER USER xxxxx WITH VALID UNTIL 'infinity';
ALTER USER
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073