Variable-length binary string type in PostgreSQL
Questions tagged [bytea]
155 questions
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…
![](../../users/profiles/2020478.webp)
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…
![](../../users/profiles/1331131.webp)
user1331131
- 327
- 3
- 16
-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…
![](../../users/profiles/2404974.webp)
Levi
- 87
- 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.
![](../../users/profiles/12484819.webp)
Praneeth Kumar
- 13
- 2
-3
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?
![](../../users/profiles/12105896.webp)
Sumeet Ambastha
- 3
- 3