Hacker News Reader

Comment by majkinetor | Hacker News Reader

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.

View on HN

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

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

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

I have just checked it via cli:

    sqlite3 -header -html foo.db

That is feature of CLI tool, not sqlite.

From command line use

     psql -H

Alternatively

     \pset format html

Again, feature of CLI tool not postgresql.

Reply on news.ycombinator.com