One more question. Does the SET PGPASSWORD sets pass for the role? If not how to set the password for the role using the script provided. 2010/10/25 Thomas Kellerer <spam_eater@xxxxxxx>: > Lukasz Brodziak, 25.10.2010 15:49: >> >> Hello, >> >> What I need to do is create a batch file to be sent to client in which >> I have to perform create role statement. Best thing would be if the >> user didn't see what is happening in the console (is there a @echo off >> equivalent for psql). Can anyone help me with this. >> > > The problem with a batch file is that you will need to provide the password > for the superuser in clear text - which is probably not something you will > want to do. > > But if that isn't a problem (and you actually know the superuser password of > your client) then the following might work: > > ------------- snip --------------- > @echo off > setlocal > > set PGHOST=localhost > set PGUSER=postgres > set PGPASSWORD=the_super_secret_password > > createuser role_1 1> nul 2>&1 > createuser role_2 1> nul 2>&1 > ... > > endlocal > ------------- snip --------------- > > > Regards > Thomas > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Åukasz Brodziak II MU Bioinformatyka -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
