Understanding the myqueries.json file
myqueries.json file is used to store your helpfull queries. Each querie you add to the json file can be searched and executed by pgAssistant. The JSON format is very simple : { "id": "db_version", "description": "Database version", "category": "Database", "sql": "SHOW server_version;", "type": "select" "reference": "https://www.postgresql.org/docs/current/sql-show.html" } id A unique ID of the query description The description of your SQL query categorie A SQL category like Database, Issue, Table, Index or whatever you want sql The SQL query ended with a “;” reference An URL on the query documentation or your project documentation type 2 sql types are alowed select : performing a select param_query : a select query with parameters. Each parameter must be in the format $1, $2, etc.