Hi Hackers, Any suggestions on the above issue.
Thanks, Pravesh On Fri, Aug 8, 2025 at 3:41 PM Pravesh Sharma < [email protected]> wrote: > 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 >
