psql currently supports HTML, CSV, etc output formats. I was wondering if supporting JSON format was requested or discussed in past. If there's desire for this feature, perhaps we can add it to the TODO list on wiki so someone can pick it up and work on it in future.
is there some standardised format for output table?
I see "-T, --table-attr=TEXT" option in `psql --help` output, presumably that's to create HTML tables.
I though for JSON format. This format is too generic.
I think I misunderstood your question earlier.
There's no standard format that comes to mind, but perhaps an output format similar to that of (array of row_to_json()) would be desirable. For example, `select relname, relnamespace from pg_class;` would emit the following: