Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA41697 for ; Wed, 17 May 2000 11:23:30 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id LAA16956; Wed, 17 May 2000 11:22:15 -0400 (EDT) To: Yamini Sharma cc: pgsql-sql@postgresql.org Subject: Re: Storing binary data in a column In-reply-to: References: Comments: In-reply-to Yamini Sharma message dated "Wed, 17 May 2000 18:13:47 +0530" Date: Wed, 17 May 2000 11:22:15 -0400 Message-ID: <16953.958576935@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200005/28 Yamini Sharma writes: > Is there any other datatype which may be used to store a > binary data string. bytea (byte array) is intended to handle this, but I seem to recall some complaints that its I/O representation is a pain to deal with. Haven't tried to use it myself. regards, tom lane