Bytea updation

From: "ramasubramanian" <ramasubramanian(dot)g(at)renaissance-it(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>, <simon(at)2ndquadrant(dot)com>
Subject: Bytea updation
Date: 2009-05-27 06:42:07
Message-ID: 4FA7F4742AD34E6F9D3B080B93808621@ramasubramanian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: Bytea updation at 2009-05-27 11:23:14 from Albe Laurenz
  • L at 2009-05-27 11:43:10 from Thomas Kellerer

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri Fontaine 2009-05-27 09:07:27 Re: Hosted servers with good DB disk performance?
Previous Message ramasubramanian 2009-05-27 06:41:30