Web DB viewer does not recognize Postgres bytea datatype
laggy_computer
HOBBYOP

7 months ago

The DB viewer in the dashboard does not correctly render the bytea type in Postgres which stores arbitrary binary data; it shows as [object Object] even though psql shows the correct hex sequence.

3 Replies

Hey! Thank you so much for reaching out. I was able to reproduce this issue. I'll let our product team know 🫡

For future reference, the test query I used

```
-- Create the table

CREATE TABLE bytea_test (

id SERIAL PRIMARY KEY,

data BYTEA

);

-- Insert some binary data (example: hex sequence \xDEADBEEF)

INSERT INTO bytea_test (data)

VALUES (E'\\xDEADBEEF');
```


Status changed to Awaiting User Response Railway 7 months ago


laggy_computer
HOBBYOP

7 months ago

Great! Would love to see this fixed as I was trying to store/view SHA checksums.


Status changed to Awaiting Railway Response Railway 7 months ago


Unfortunately I don't have an ETA :/ Will let you know if this changes


Status changed to Awaiting User Response Railway 7 months ago


Loading...