pg_tmp_lets_me_truncate

pg_tmp_lets_me_truncate.sh

#!/bin/sh

uri=$(pg_tmp)
psql --no-psqlrc "$uri" -c "SELECT SESSION_USER, CURRENT_USER;"
psql --no-psqlrc "$uri" -c "CREATE TABLE dirs (id bigserial PRIMARY KEY);"
psql --no-psqlrc "$uri" -c "REVOKE TRUNCATE ON dirs FROM current_user;"
psql --no-psqlrc "$uri" -c "TRUNCATE dirs;"

# ./pg_tmp_weirdness
 session_user | current_user
--------------+--------------
 at           | at
(1 row)

CREATE TABLE
REVOKE
TRUNCATE TABLE

postgresql 12.2 on NixOS