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 D7738563CE for ; Mon, 14 Mar 2005 08:46:28 +0000 (GMT) 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 30631-07 for ; Mon, 14 Mar 2005 08:46:27 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id ACD0D56381 for ; Mon, 14 Mar 2005 08:46:26 +0000 (GMT) Received: from gnari ([157.157.184.242] [157.157.184.242]) by quasar.skima.is with ESMTP; Mon, 14 Mar 2005 08:46:27 Z Subject: Re: How to cast VARCHAR to BYTEA and vice-versa? From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: "Moran.Michael" Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Mon, 14 Mar 2005 08:46:33 +0000 Message-Id: <1110789993.12425.16.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/190 X-Sequence-Number: 20669 On Tue, 2005-03-08 at 07:31 -0800, Moran.Michael wrote: > Hello all, > > I have a table with a VARCHAR column that I need to convert to a BYTEA. > > How do I cast VARCHAR to BYTEA? have you looked at the encode() and decode() functions ? http://www.postgresql.org/docs/7.4/interactive/functions-string.html gnari