Hi Hackers, I'm working on feature #4011 <https://github.com/pgadmin-org/pgadmin4/issues/4011>, which involves exporting and importing BLOB (bytea) data. I've checked its feasibility and these are the challenges I'm facing:
Currently, we simply return the string "binary data" for bytea columns, and we don't load the actual binary data at all. If we want to download this data, we can bring it to the cursor, but when returning it to the front end, we'll still send the string "binary data" Upon a user's request to download, we'll fetch it from the cursor and return it. The main challenge I'm facing is how we'll identify the row from which the download needs to happen if there's no primary key in the table. Additionally, keeping binary data in memory could cause performance issues. For this reason, we can make it a preference-based option. Please let me know your thoughts/suggestions. Thanks, Pravesh -- Pravesh Sharma Senior SDE +91 9406461406 enterprisedb.com
