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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>