How to create a GENERIC live template with named parameters for ANY PostgreSQL stored procedure
Because PostgreSQL supports named parameters in Stored Procedures & Functions, GIVEN a PostgreSQL stored procedure like `add_article(article_title TEXT, article_txt TEXT, comment TEXT)`, if you type `add_article()` and press `<Ctrl><Space>` for ToolTip/Autocomplete while the cursor is inside the parenthesis, there is no autocomplete
Is it possible to create a GENERIC live template for any existing Stored Procedure or Function like `add_article(article_title => , article_txt => , comment => )` so that we can tab through and fill the parameters.
请先登录再写评论。
It is impossible to do this trick.
Are you using parameter info (Cmd+P) along with the parameter completion? https://imgur.com/nhexnL0
That should help.
Hey, what I just discovered: press Ctrl/Cmd + Space TWICE: the named parameter will be offered in the first place.
Wow. the Ctrl + Space TWICE is super cool.
Thanks