Re: binary data

From: hughmandeville(at)hotmail(dot)com (Hugh Mandeville)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: binary data
Date: 2001-06-13 23:24:11
Message-ID: ae21865c.0106131524.607c80c2@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pasi Salminen 2001-06-14 08:12:12 Timestamp without time zone
Previous Message Tom Lane 2001-06-13 21:38:45 Re: large going giving errors.