how to get characters between [ ] in postgresql
I want get characters between [] from a string example: "hello" and "world" from "gegerferf[hello] frfer [world] frfre rfrf" into a table i am try with substring and for loop but i dont now. select regexp_replace(string, '...','', 'g') from mytable