'-W' option is there to prompt the password. Use PGPASSWORD environment variable. http://www.postgresql.org/docs/8.3/static/libpq-envars.html
*createdb creates a PostgreSQL database.* * * *Usage:* * createdb [OPTION]... [DBNAME] [DESCRIPTION]* * * *Options:* * -D, --tablespace=TABLESPACE default tablespace for the database* * -e, --echo show the commands being sent to the server* * -E, --encoding=ENCODING encoding for the database* * -l, --locale=LOCALE locale settings for the database* * --lc-collate=LOCALE LC_COLLATE setting for the database* * --lc-ctype=LOCALE LC_CTYPE setting for the database* * -O, --owner=OWNER database user to own the new database* * -T, --template=TEMPLATE template database to copy* * --help show this help, then exit* * --version output version information, then exit* * * *Connection options:* * -h, --host=HOSTNAME database server host or socket directory* * -p, --port=PORT database server port* * -U, --username=USERNAME user name to connect as* * -w, --no-password never prompt for password* * -W, --password force password prompt* On Thu, May 19, 2011 at 8:23 PM, Mahmoud <mhha...@gmx.com> wrote: > Hi all > I am trying to create a database by passing arguments to createdb.exe but > createdb always asks me about the password although I passed -W 123 to it. > > How can I override password request? > > PS > This my test for creating the database > createdb.exe -U postgres -W 123 -O admin -e test > > Cheers. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
