Skip site navigation (1) Skip section navigation (2)

Workaround for html output formatting feature?

From: Marc Howard Zuckman <marc(at)fallon(dot)classyad(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Workaround for html output formatting feature?
Date: 2001-09-07 03:29:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
There is a change in html output construction in the 7.1 series
that I have had difficulty handling.

In a prior version (7.0.x, I think) invoking psql with -H command line
switch and a select statement of the following form:

select '<a href="' || table.url || '">' || 'link text </a>' from table
   where ....

produced a  html table with "clickable" links.

In 7.1.3, if html output is selected, the angle brackets are
output as &lt; or &gt;  .  I see the need for the change in
this behaviour, but it hampers my use of postgresql to generate
html tags.

Modifying the select statement to include hex or octal character
equivalents for the angle brackets produces the same results as does
use of the &#9001; / &#9002; constructs.

Short of outputing the query results as text and generating
the html on my own, is there an intrinsic postgresql solution to
this issue?

Marc Zuckman

pgsql-bugs by date

Next:From: Marc G. FournierDate: 2001-09-07 03:32:12
Subject: pgsql/src/backend/utils/mb encnames.c win1251. ...
Previous:From: Łukasz SkowrońskiDate: 2001-09-07 03:16:26
Subject: Huge view file

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group