On 2020/08/18 4:52, David Gauthier wrote:
Thanks in advance for any replies/ideas !
You could hackily repurpose the "application_name" connection parameter: $ whoami ibarwick $ psql -d "host=localhost dbname=postgres user=postgres application_name=$USER" psql (14devel) Type "help" for help. postgres=# SELECT application_name FROM pg_stat_activity WHERE pid=pg_backend_pid(); application_name ------------------ ibarwick (1 row) Disclaimer: I have not applied any thought to any possible pitfalls and side effects resulting from this approach. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
