Michael A. Schulte wrote: > Hi, > > does anyone have an idea how to convince psql > to accept a password that is passed during startup > of psql in the command line? > > I don't want to modify pg_hba.conf so that it > is open for everyone so I have inserted: > > local all trust > host all 129.157.0.0 255.255.0.0 password > > > I look for something like: > psql -h somehost -a dash anonymous/anonym > where there exists a postgres user named "anonymous" > and the password is anonym.
Try (assume a sh or ksh shell): PGPASSWORD=anonym psql -h somehost -U anonymous -a dash HTH, Kevin ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
