4 ms·
They have an option to change query result into JSON, not HTML AFAIK (although nothing stops you to do that with strings). You still need to provide UI for json
by majkinetor 6y ago
They have an option to change query result into JSON, not HTML AFAIK (although nothing stops you to do that with strings). You still need to provide UI for json via some javascript frameworks such as Vue.js.
- nabla9 6y agoThere is an option to change query result to HTML in both. I checked.
- majkinetor 6y agoYou are wrong. Give us reference for native html function in postgres and not string massage.
- nabla9 6y agoFrom command line use psql -H Alternatively \pset format html
- majkinetor 6y agoAgain, feature of CLI tool not postgresql.
- stephen82 6y agohttps://www.sqlite.org/cli.html#dotmode https://www.sqlite.org/cli.html#dotmode I have just checked it via cli: sqlite3 -header -html foo.db
- majkinetor 6y agoThat is feature of CLI tool, not sqlite.