Require suggestions on feature 4011

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