> On Sep 9, 2019, at 7:16 AM, nikhil raj <nikhilraj474@xxxxxxxxx> wrote: >> /usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d $DBLIST -c "GRANT CONNECT ON DATABASE $DBLIST TO cpupdate" >> ERROR: database "cdf_100_1313" does not exist This still isn't quoted properly. It's tricky since double-quote is special to both the shell and SQL. You need something like /usr/lib/postgresql/11/bin/psql -p 5432 -U postgres -d "$DBLIST" -c "GRANT CONNECT ON DATABASE \"$DBLIST\" TO cpupdate" regards, tom lane
