SMOLNET PORTAL home about changes

postgresql get current query


postgresql logging in custom functions.
if you develop postgres plpgsql function sometimes you need to log something. you can add to log info from this select to determine what first query in transaction was perfotmed.

select current_query();


๐Ÿš€ asriyanarthur

Apr 12 ยท 6 months ago ยท ๐Ÿ‘ lufte

Response: 20 (Success), text/gemini
Original URLgemini://bbs.geminispace.org/u/asriyanarthur/16100
Status Code20 (Success)
Content-Typetext/gemini; charset=utf-8