Re: binary data - Mailing list pgsql-sql

From hughmandeville@hotmail.com (Hugh Mandeville)
Subject Re: binary data
Date
Msg-id ae21865c.0106131524.607c80c2@posting.google.com
Whole thread Raw
In response to binary data  (David Lizano <david.lizano@izanet.com>)
Responses Re: Re: binary data
List 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.


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: possible to lock a single row in table?
Next
From: Lamar Owen
Date:
Subject: Re: [GENERAL] Re: ORDER BY what?