Question 203662 in PostgreSQL Question posted in
The official documentation can be found here.

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
Tags:

2

Answers


  1. 0

    The question didn’t provide an example of the expected results, so I’ll present a couple of options.

    The following is run to setup the demonstration context:

    CREATE TABLE t (
  id serial primary key,
  string text
);

INSERT INTO t(string)
VALUES ('gegerferf[hello] frfer [world] frfre rfrf');

    This query returns the text between brackets concatenated into a single string:

    SELECT regexp_replace(string, '[^[]*[([^]]*)][^[]*', '1', 'g')
  FROM t;

    The result is:

     regexp_replace 
----------------
 helloworld
(1 row)

    This query returns the text between brackets as separate rows:

    SELECT (regexp_matches(string, '[([^]]*)]', 'g'))[1]
  FROM t;

    The output is:

     regexp_matches 
----------------
 hello
 world
(2 rows)
    Login or Signup to reply.
  2. 0 
    SELECT  (REGEXP_MATCHES('gegerferf[hello] frfer [world] frfre rfrf','(?:[)(.*?)(?:])','g'))[1];
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search