TablePlus icon indicating copy to clipboard operation
TablePlus copied to clipboard

Export in CSV and JSON does not work for binary data

Open mark-b-ab opened this issue 3 years ago • 2 comments

Which driver are you using and what version of it (Ex: PostgreSQL 10.0): PostgreSQL 13.0

Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 411

When I export a table with bytea column, it gets replaced with a string saying 32 bytes.

Ex.

{ "number": 0, "timestamp": "1970-01-01 03:00:00+03", "nonce": "8 bytes", "hash": "32 bytes", "parent_hash": "32 bytes", "gas_used": 0, "gas_limit": 5000, "difficulty": 17179869184, "total_difficulty": 17179869184, "miner": "20 bytes", "size": 540, "state_root": "32 bytes", "extra_data": "32 bytes", "sha3_uncles": "32 bytes" },

mark-b-ab avatar Mar 31 '22 06:03 mark-b-ab

Bumping for visibility. Ran into this today.

TheSameCat2 avatar Oct 25 '23 14:10 TheSameCat2

Bumping this as well. It would be awesome if binary data could be included as hex strings (or any other exportable format, base64, etc).

d53dave avatar Jul 22 '24 12:07 d53dave