Re: Binary data Insertion.

Bytea. Its not very documented, but you can use it.

create table foo(
a int4,
v bytea)

insert into foo values (1, '\001\002\\000');

note the double backslash for null character.

On Wed, 27 Jun 2001, Namrata wrote:

> Hi there,
>
> How Binary data is inserted in the database?
>
> I want to put the binary data in the database as a record.
>
> Which data type I should use?
>
> Thanks,
> Namrata.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>