Re: [GENERAL] import_bytea function

[Thomas Kellerer]

Stephen Davies schrieb am 08.10.2016 um 02:57:

A follow-up question.
Once the bytea column is populated, how best to display  the content in a web 
page?

I have :

byte [] imgB;
ResultSet rs = st1.executeQuery("select pic from part where pno='" + p + "'");
      if(rs.next()){
          imgB = rs.getBytes(1);
          if (imgB != null){
            out.write("Content-type: image/jpeg");
            out.write("Content-length: " + (int)imgB.length);
            out.write(imgB.toString());
          }
      }

but this does not work.
The toString() looks wrong but removing it makes the write fail.

What is "out"?

(And please use a PreparedStatement to run the SELECT for security reasons)




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general