Jane Ren wrote:
Hi, I need to write a script that creates a new user with a password automatically. Is there a way I can specify the password as a command line argument to createuser?
Since you have access to the shell use psql -U user -c "create role ..." Joshua D. Drake
It looks like postgres does not read from stdin, but from /dev/tty. Thanks ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings