Bytea updation

thread

List

Post date

Sort by

From:	ramasubramanian
Subject:	Bytea updation
Date:	May 27, 2009 , 06:49:06
Msg-id:	4FA7F4742AD34E6F9D3B080B93808621@ramasubramanian (view: Whole thread, Raw)
Responses:	Re: Bytea updation ("Albe Laurenz") L (Thomas Kellerer)
List:	pgsql-performance

Dear Friends,

How to insert or update a file in a table using the query in postgres
CREATE TABLE excel_file_upload
(
user_id integer,
excel_file bytea

}

example

insert into excel_file_upload values(1,file1)

file1 can be any file *.doc,*.xls

How i can do this(with out using java or any other language) using query?

Please help me out

Regards,

Ram

From: Thomas Kellerer
Date: 27 May 2009, 06:05:34
Subject: L

From: Alan McKay
Date: 27 May 2009, 07:24:56
Subject: running bonnie++