yes, there is no other way to provide a password through command line for postgresql psql command line