You can also shell out to a command with \! and send data one way using a combo of \gset and \setenv, then bundle up the whole "function" as a .sql file you include when you want it with \i. For example here's a snippet I use to get the session pid, export it, then fire up another tmux pane running gdb attached to my session and then continue:
I was wondering : is it possible to add directly a new psql command which can be run anytime in our PostgreSQL interpreter like any other normal psql commands ?
I explain myself : in the PostgreSQL interpreter, when the command "\h" or "\help" is written in the shell, we can see all the commands we have at our disposal. We can also of course write our proper functions, in python scripts for example, and run them direclty in one of our databases. But I was wondering if it was possible to add directly a command, like \copy, \select, .... For example, let's say I create a new command called \resume which will call my own-made python script, and I would want this command to be part of the list of commands we see when we type \h.
Is it even possible ? And if it's possible, how can I achieve that ?
Thanks for your attention and I thank you in advance for all the informations you will possibly give me.
It is not possible. psql is not designed to be enhanced.
you can use psql variables for this purpose partially