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

How to html-decode a html-encoded field

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to html-decode a html-encoded field
Date: 2012-04-10 15:59:13
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
I have a table with a varchar field, such a field is HTML ENCODED. So, for
example, the string "PLAIN WHITE T'S" is saved as "PLAIN WHITE
T&#39;&#39;S" (double quotes are not part of the string, I use them for
clarity only). I need to perform a SELECT statement on this table and get
the values HTML DECODED and I wonder if there is a function that I can
include in such a statement for this purpose, for example "SELECT
htmldecode(fld1) FROM table1". I will appreciate anu comments about my

Jorge Maldonado


pgsql-sql by date

Next:From: Pavel StehuleDate: 2012-04-10 16:01:38
Subject: Re: How to html-decode a html-encoded field
Previous:From: Rob SargentDate: 2012-04-06 20:14:40
Subject: Re: syntax of joins

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