Re: Password issue

'-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 <mhhasan(at)gmx(dot)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(at)postgresql(dot)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>