[GENERAL] psql HTML mode - quoting HTML characters

[Nicholson, Brad (Toronto, ON, CA)]

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">&lt;a 
href=http://www.postgresql.org&gt;Postgres&lt;/a&gt;</td>
  </tr>
</table>
<p>(1 row)<br />
</p>


I would like the line 

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

To be

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

Thanks,
Brad

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general