Hi
long time we are think how to allow add some custom commands in psql. I had a following idea
1. psql can has special buffer for custom queries. This buffer can be filled by special command \gdefq. This command will have two parameters - name and number of arguments.
some like
select * from pg_class where relname = :'_first' \gdefcq m1 1
select * from pg_class where relnamespace = :_first::regnamespace and rename = :'_second' \gdefcq m1 2
the custom queries can be executed via doubled backslash like
\\m1 pg_proc
\\m1 pg_catalog pg_proc
the runtime will count number of parameters and chose variant with selected name and same number of arguments. Next, it save parameters to variables like _first, _second. Last step is query execution.
What do you think about this?
Regards
Pavel