ALTER USER postgres WITH PASSWORD '[enter password]'
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-alteruser.htm
----- Original Message -----
From: "Leon van Dongen" <Leonvd@kabelfoon.nl>
To: <pgsql-general@postgresql.org>
Sent: Monday, December 18, 2000 1:56 AM
Subject: [GENERAL] newbie question:
> I have been expirementing with PostgreSQL
> but now I have compiled PHP with PostgreSQL
> I need an superuser to call the database from my scripts.
>
> Postgres is already defined as the superuser but how
> can I set the superuser password ?
> Is there a admin script just like MySQL or should
> I insert it into the pg_??(group,user) table on the
> default database ?
>
> please let me know
>
>
> Leon