Postgres Pro
Downloads
Home   >   mailing lists

Re: How to transfer binary data into a BIT VARYING column ? - Mailing list pgsql-odbc

From Tom Lane
Subject Re: How to transfer binary data into a BIT VARYING column ?
Date
Msg-id 14575.1242746311@sss.pgh.pa.us
Whole thread Raw
In response to How to transfer binary data into a BIT VARYING column ?  (Timothy Madden <terminatorul@gmail.com>)
Responses Re: How to transfer binary data into a BIT VARYING column ?  (Timothy Madden <terminatorul@gmail.com>)
List pgsql-odbc
Tree view 
Timothy Madden <terminatorul@gmail.com> writes:
> I have a BIT VARYING(83886080) column in my table and I would like to
> store file attachments
> in it.

Use bytea.

> I would like to use BIT VARYING because it is an ANSI-conformant
> binary type, while bytea and 'lo' are not ANSI SQL.

Considering the nonstandard things you will have to do to get data into
the column, this seems like a pretty silly argument.

            regards, tom lane

pgsql-odbc by date:

Previous
From: Timothy Madden
Date:
Subject: How to transfer binary data into a BIT VARYING column ?
Next
From: Timothy Madden
Date:
Subject: Re: How can I bind query parameters to variables ?