| From: | Michael Monnerie <michael(dot)monnerie(at)is(dot)it-management(dot)at> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Subject: | Re: type cast from bytea to varchar or whatever |
| Date: | 2009-09-16 05:01:44 |
| Message-ID: | 200909160701.45303@zmi.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Dienstag 15 September 2009 Kevin Grittner wrote:
> http://www.postgresql.org/docs/8.4/interactive/functions-string.html
>
> I would have thought convert_from, possibly combined with convert,
> would do it.
That function exists since 8.3, I'm on 8.1 on my server. Will forward it
to others, and try to push my server to 8.3 quickly.
Thank you for the hint!
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Samokhin | 2009-09-16 09:14:55 | pgAgent Windows service startup time |
| Previous Message | Thomas Kellerer | 2009-09-15 21:05:16 | Re: setting pg memory consumption on windows |