How to filter records in postgreys table with bytea field ?
How to filter records in postgreys table with bytea field ?
Before telling about solution please avoid storing data in postgrey bytea field if you need a filter on stored data, instead store it in jsonb data type. Yes but we don’t have all time a luxury to change the data type if we are working on a legacy system. hence if you are in the same boat you can write the queries as mentioned below. Take example of following json stored in bytea data type of…
View On WordPress











