BUG #16816: Unexpected escaping of html output
От | PG Bug reporting form |
---|---|
Тема | BUG #16816: Unexpected escaping of html output |
Дата | |
Msg-id | 16816-4c7637cc57fba45f@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16816: Unexpected escaping of html output
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16816 Logged by: Jeroen Baten Email address: jbaten@i2rs.nl PostgreSQL version: 12.5 Operating system: Ubuntu Linux 20.04 Description: Hi, I am not sure if this is a bug, but I can't see to find any place (web/books/google/irc) that has a solution to my problem. So, in the end, I turn to the development team. My problem is: I use psql --html to generate output that I then transform to pdf using wkhtmltopdf. psql --html escapes html that I purposely enter into the select statement. (As I user I would like to be able to generate html in my select statements, even when using the html format output format) Example: Running psql --html select format('<a href="https://zammad.thuis.local#ticket/zoom/%s">%s</a>',t.number,t.number) as TicketID from tickets as t, users as u where t.owner_id=u.id and date(t.close_at) is null and t.owner_id=u.id order by t.close_at limit 1 ; <table border="1"> <tr> <th align="center">ticketid</th> </tr> <tr valign="top"> <td align="left"><a href="https://zammad.thuis.local#ticket/zoom/85117">85117</a></td> </tr> </table> <p>(1 row)<br /> </p> Running psql without --html ticketid ------------------------------------------------------------------ <a href="https://zammad.thuis.local#ticket/zoom/85117">85117</a> Any and all help is highly appriciated. Kind regards, Jeroen Baten <jbaten@i2rs.nl>
В списке pgsql-bugs по дате отправления: