Variable-length binary string type in PostgreSQL
Questions tagged [bytea]
189 questions
0
votes
1 answer
Insert image from PostgreSQL database
I am using iReport 5.0 and I am trying to insert picture from database.
The picture is stored in PostgreSQL in a bytea type field
I already tried solution, but it does not work
If I use JRImageLoader.loadImage((byte[])$F{slike}) in image expression…
Yebach
- 1,661
- 8
- 31
- 58
0
votes
2 answers
PostgreSQL: unable to save special character (regional language) in blob
I am using PostgreSQL 9.0 and am trying to store a bytea file which contains certain special characters (regional language characters - UTF8 encoded). But I am not able to store the data as input by the user.
For example :
what I get in request…
Kuber
- 45
- 2
- 7
0
votes
1 answer
Retrieving image file from Postgresql database returns two times bigger data inserted (by libpq library)
I'm using libpq library of Postgresql database and I have a problem about retrieving the bytea data from db. I couldn't solve my problem, so wanted to ask you. Whenever I try to insert an image file into db and get it back, the size of returning…
Horizon1710
- 792
- 10
- 28
0
votes
1 answer
Error about sending an image into bytea column in postgresql db with libpq library
I'm coding in C and using Libpq library of Postgresql and I would like to store a PNG image into the database in "bytea" type. I have been searching on the net for hours and couldn't find a good example to handle this work, so wanted to write here…
Horizon1710
- 792
- 10
- 28
0
votes
1 answer
Preparing, Storing, Retrieving Encrypted Data in PostgreSQL
Does anyone know how to properly prepare for BYTEA data type insertion into postgresql? I have an encrypted string generated from libmcrypt. I am I wish to store the encryption in a table column defined as
"cdata bytea not null"
I have the…
Rico
- 11
- 6
0
votes
1 answer
Postgres - Convert bytea PNG column to GeoTiff
I have loaded a massive set of tiles into a postgres database for use in a tile server. These were all loaded into bytea columns in PNG format.
I now find out that the tile server code needs these to be in GEOTiff format.
The…
user1331131
- 427
- 6
- 20
-1
votes
1 answer
Sequel Ruby reading bytea data type
I am trying to decode a json mime type stored in bytea column in postgres using sequel. I remember I used some kind of method passing it mime type and data. But I cannot find it in my code and documentation.
I have bytea column and info about mime…
Levi
- 77
- 7
-1
votes
1 answer
image upload using a postgres bytea blob field in laravel
I am unable to find any article on how to store and retrieve image in postgres using bytea in laravel project. I am particularly looking on save and and retrieve data using ajax call.
Praneeth Kumar
- 23
- 4
-2
votes
2 answers
How to read column in postgres DB of data type BYTEA and encoding of compressed json using PYTHON
I have a column in postgres DB of data type bytea and encoding is of compressed_json. How can I read the values of this column and get a proper json back in Python?
Sumeet Ambastha
- 15
- 4