Обсуждение: Binary data Insertion.

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.

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