[majkinetor]

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]

There is an option to change query result to HTML in both. I checked.

[majkinetor]

You are wrong. Give us reference for native html function in postgres and not string massage.

[stephen82]

https://www.sqlite.org/cli.html#dotmode

I have just checked it via cli:

    sqlite3 -header -html foo.db

[majkinetor]

That is feature of CLI tool, not sqlite.

[nabla9]

From command line use

     psql -H 

Alternatively

     \pset format html

[majkinetor]

Again, feature of CLI tool not postgresql.