pgbenchshell_test.sql

application/octet-stream

Filename: pgbenchshell_test.sql

Type: application/octet-stream

Part: 1

Message: Re: pgbench: new feature allowing to launch shell commands

\set naccounts 100000 * :scale

-- Should works
\setshell aid expr 1 + :naccounts

-- *Shouldn't* work.
-- \setshell :aid expr 1 + :naccounts

-- :aid should be replaced, but ::aid *shouldn't*.
\shell echo ::aid :aid selected from :naccounts accounts
DO $$ BEGIN RAISE INFO ':aid vs. ::aid'; END; $$ LANGUAGE plpgsql;