psql HTML mode - quoting HTML characters

From: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: psql HTML mode - quoting HTML characters
Date: 2011-10-26 19:51:55
Message-ID: EC55DC235432104F8255702A8D7344D9256BD52B@G9W0741.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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">&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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2011-10-26 20:15:35 Re: Saving score of 3 players into a table
Previous Message Chris Redekop 2011-10-26 17:41:38 Re: Can someone help explain what's going on from the attached logs?