Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5KGR9a84933 for ; Wed, 20 Jun 2001 12:27:09 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DNTCE61565 for ; Wed, 13 Jun 2001 19:29:12 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f5DNOFk46822 for pgsql-sql@postgresql.org; Wed, 13 Jun 2001 19:24:15 -0400 (EDT) (envelope-from news) From: hughmandeville@hotmail.com (Hugh Mandeville) X-Newsgroups: comp.databases.postgresql.sql Subject: Re: binary data Date: 13 Jun 2001 16:24:11 -0700 Organization: http://groups.google.com/ Lines: 15 Message-ID: References: <4.3.2.7.0.20010529182952.00c5cde0@mail.izanet.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-support@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200106/308 X-Sequence-Number: 3571 > Is there any method to insert binary data in a PostgreSQL row? i'm curious too. Chapter 3. of the PostgreSQL 7.1 User's Guide has a description of the data types. http://www.postgresql.org/idocs/index.php?datatype.html i couldn't find any official binary data type listed. you might try using the text data type and uuencode the data on the way in and uudecode it on the way out. the doc note section does mention the "bytea" data type, which works, but i don't know if it is supported or its limitations.