Thank you very much for your support. After setting the "bytea_output" to "escape" and increasing the Java heap size of DBeaver (to 8GB), I can now see the big column (bytea > 500MB). I am still in the testing phase and haven't finished yet, but I wonder if clients with small RAM will be able to select these big columns or if bytea_output=escape will be visible in the application. Could you please explain this to me in more detail?
> I created a big bytea value and try to select it from a table, I get > an error, something like: "ERROR: invalid memory alloc request size > ...". > it means i can insert data into table but then i can't even work > with it. is it a bug? could you please help me to solve this Problem. > Thank you very much for your support
This is a known (but not documented as far as I know) issue, but it also depends on the data contents and how the value is retrieved. Possible workarounds:
1. If the data is largely printable ASCII, then try setting "bytea_output" to "escape":