psql HTML mode - quoting HTML characters - Mailing list pgsql-general

Hi,

How do I quote characters like < and > in psql's HTML mode?

For example:


Regular mode:
postgres=# select '<a href=http://www.postgresql.org>Postgres</a>';
                    ?column?
------------------------------------------------
 <a href=http://www.postgresql.org>Postgres</a>
(1 row)

HTML mode:
postgres=# \H
Output format is html.
postgres=# select '<a href=http://www.postgresql.org>Postgres</a>';
<table border="1">
  <tr>
    <th align="center">?column?</th>
  </tr>
  <tr valign="top">
    <td align="left"><a href=http://www.postgresql.org>Postgres</a></td>
  </tr>
</table>
<p>(1 row)<br />
</p>


I would like the line

<td align="left"><a href=http://www.postgresql.org>Postgres</a></td>

To be

<td align="left<a href=http://www.postgresql.org>Postgres</a></td>

Thanks,
Brad