Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group