Postgres 9.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table "Table"("column" text);
insert into "Table" values 
  ('GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT')
  returning *;

column

GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT

INSERT 0 1

--https://stackoverflow.com/q/77915210/5298879
SELECT "column" from "Table" LIMIT 1;

column

GLOBE-WORLD-AIRPORT-Azerbaijan-country-SECRET-ABORT

SELECT 1

select regexp_replace(
            regexp_replace( "column"
                           ,'^([^-]*-){3}'
                           ,'')
           ,'(-[^-]*){2}$'
           ,'')
from "Table"
limit 1;

regexp_replace

Azerbaijan-country

SELECT 1

insert into "Table" values 
  ('---Thee-hyphens-before-and-two-after--'),
  ('------')--6 dashes/hyphens, so it should return only one
returning regexp_replace(regexp_replace("column",'^([^-]*-){3}', ''),'(-[^-]*){2}$','');

regexp_replace

Thee-hyphens-before-and-two-after

-

INSERT 0 2

select array_to_string(w[4:array_upper(w,1)-2],'-')
from "Table",
regexp_split_to_array("column",'-')_(w);

array_to_string

Azerbaijan-country

Thee-hyphens-before-and-two-after

-

SELECT 3