Postgres display a query result into html format

Question

Is there any way to run a query and the resulted output to become into an html format. The query may be into a store procedure, for convenience. As an example usage, I think something like that:

select * from my_stored_proc(arg1, arg2) -> [html formated] result set

or any other way.

According to the documentation using the -H switch with pgsql command line states a return in HTML type. — Gurmokh
– Gurmokh, Commented Jun 30, 2017 at 7:39

Aashutosh Rathi · Accepted Answer · 2020-08-13 10:02:56Z

3

I found this accidentally, I was using psql -H <connectionString> and was not sure why I was getting HTML outputs.

I found it later -H was flag for getting all HTML responses from psql.

answered Aug 13, 2020 at 10:02

Aashutosh Rathi

7962 gold badges13 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vao Tsun · Accepted Answer · 2017-06-30 08:00:35Z

2

I doudbt you gonna use psql output to render the page, so probably -H is not an option. and there is no other "native" html conversion in Postgres afaik. I'd rather use js parser to consume xml or json, returned by Postgres instead... (I believe most API calls return either json or xml, so parsing should be very common)

Also, look for similar questions, eg Generate HTML from PostgreSQL function

answered Jun 30, 2017 at 8:00

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Collectives™ on Stack Overflow

Postgres display a query result into html format

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related