PostgreSQL 8.2.3 Documentation - createuser - echoed command

[Halley Pacheco de Oliveira <halleypo(at)yahoo(dot)com(dot)br>]

In the createuser command page is written:

To create the user joe as a superuser, and assign a password immediately:

$ createuser -P -s -e joe
Enter password for new role: xyzzy
Enter it again: xyzzy
CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
CREATE ROLE

In the above example, the new password isn't actually echoed when typed, but we show what was typed for clarity. However the password will appear in the echoed command, as illustrated — so you don't want to use -e when assigning a password, if anyone else can see your screen.

But it is not always the truth.

When I use

$ createuser -P -s -N -e joe

I get:

Enter password for new role: xyzzy
Enter it again: xyzzy
CREATE ROLE joe PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
CREATE ROLE

(same as in the documentation)

But when I use

$ createuser -P -s -E -e joe

(or don't use -N or -E) I get:


CREATE ROLE joe ENCRYPTED PASSWORD 'md5b5f5ba1a423792b526f799ae4eb3d59e' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

(the password is shown encrypted)

The last two examples were executed using a "createuser (PostgreSQL) 8.2.0" local.

But when I execute the createuser command from a remote machine using:

# createuser --version
createuser (PostgreSQL) 8.1.4

# createuser -h Kubuntu -U sistemas -P -s -E -e joe

I get:

CREATE ROLE joe ENCRYPTED PASSWORD 'xyzzy' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

(same as in the documentation, but different from the createuser 8.2.0 local)

I would like to know the reason of the difference. Is it being caused by the different versions of createuser?

The text is the same in the PostgreSQL 8.1.8 Documentation and in the PostgreSQL 8.2.3 Documentation, but it seems to me that the createuser behaviour is different in these versions.

Thanks,
Halley





__________________________________________________
Fale com seus amigos  de graça com o novo Yahoo! Messenger 
http://br.messenger.yahoo.com/