On 3/29/19 3:01 PM, Pavel Stehule wrote: > But psql has safe escaping via :"xxx" notation. So some like > > psql -c 'create role :"role"' -v role='my role' ... > > But what I know the psql variables are not evaluated for -c query
You can do this: echo "create role :\"role\"" | psql -v role='my role' CREATE ROLE echo "\password :\"role\"" | psql -v role='my role' Enter new password: Enter it again: That said, this is kind of off the topic of this thread. I like Tom's last suggestion of: pg_util <command> <options> Of course that does not lend itself to symlinking for backward compatibility, does it? If there is a way I am not familiar with it. I guess the alternative would be an alias, but can packages install an alias? Or something else I am not thinking about? Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development