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:
Show quoted text
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