X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 424F9D1B377 for ; Fri, 16 Jul 2004 17:18:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25383-10 for ; Fri, 16 Jul 2004 20:18:15 +0000 (GMT) Received: from FW01.powerupnetworks.com (fw01.powerupnetworks.com [67.95.85.164]) by svr1.postgresql.org (Postfix) with ESMTP id 20E45D1B241 for ; Fri, 16 Jul 2004 17:18:11 -0300 (ADT) Received: from hermes.internal.powerupnetworks.com ([192.168.21.6]) by FW01.powerupnetworks.com (8.12.9/8.11.6) with ESMTP id i6GJYvMM012614 for ; Fri, 16 Jul 2004 14:34:57 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: BYTEA output presentation Date: Fri, 16 Jul 2004 15:18:13 -0500 Message-ID: <3AE153EDD5CA7B4CBA26FCDA1CBA6478403412@hermes.internal.powerupnetworks.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: BYTEA output presentation thread-index: AcRrcgVf9e/JffZoQICcEaWkZ+pxmw== X-Priority: 1 Importance: high From: "Peter Wang" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.3 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME, X_PRIORITY_HIGH X-Spam-Level: * X-Archive-Number: 200407/106 X-Sequence-Number: 18358 I output the BYTEA datatype for a table in our database. The BYTEA data look like "/031/024/001/003?/022/....".=20 How can I use some PostgreSQL function to remove "/" when I use select stat= ement ? What type of format is the BYTEA datatype? Can I output it to hexadecimal o= r octal format ? If you can, how ?=20 Or do you know any third party tool or script which can output the hexadeci= mal or octal format for PostgreSQL's BYTEA datatype ?=20 Your help is appreciated. Thank you.=20 Peter Wang,