Re: psql HTML mode - quoting HTML characters

From: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql HTML mode - quoting HTML characters
Date: 2011-10-26 21:08:07
Message-ID: EC55DC235432104F8255702A8D7344D9256BD5BB@G9W0741.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: Josh Kupershmidt [mailto:schmiddy(at)gmail(dot)com]
> Sent: Wednesday, October 26, 2011 5:04 PM
> To: Nicholson, Brad (Toronto, ON, CA)
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] psql HTML mode - quoting HTML characters
>
> On Wed, Oct 26, 2011 at 3:51 PM, Nicholson, Brad (Toronto, ON, CA)
> <bnicholson(at)hp(dot)com> wrote:
> > How do I quote characters like < and > in psql's HTML mode?
>
> From a brief look at print_html_text() and html_escaped_print() in
> psql's print.c, I don't see any way to tell psql not to escape some
> block of text in HTML print mode.

Darn. Thanks though.

> Out of curiosity, what do you find psql's HTML mode useful for?

Quick and dirty reporting. Set the HTML mode, run a query, and dump the output into Apache's document directory and you have a very quick, albeit crude way to present results.

Brad.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2011-10-26 21:11:33 Re: Saving score of 3 players into a table
Previous Message Josh Kupershmidt 2011-10-26 21:03:42 Re: psql HTML mode - quoting HTML characters