Hello,

I am using SB to install Postgres along with my app - this works fine. But I
am trying to create a new database in Postgres via SB script and having a
problem.

I am using SB run program with this result:

run C:\PG\bin\createdb.exe -h localhost -p 5432 -D pg_default -T
template0 -E WIN1252 -O postgres newdbname

This works fine as far as calling and running createdb.exe but I am always
prompted for a password. If I enter the password (during the SB install
running) then the database is properly created so I know my command line is
correct. But I want to make this password-entry free and did some research
on createdb. Supposedly, I can set the Postgres environmental variable
PGPASSWORD to the proper password before createdb is run and I will not be
asked for a password.

I use SB to set the PGPASSWORD environmental variable just before running
createdb but it does not work - still asked for a password.

Anyone have any suggestions?

regards,

Chuck