title: POSTGRES SQL query to find all the rows which have one column contains number with format like 11 digits - 4 digits
body: <p>I am trying to write one postgress sql query , here i want to select all the rows , for which one column must contains string of below format , i am not able to construct regular expression for postgress , as am new to this DB </p>
  
  <p>one column contains a string like   PRF:12345678901-1234  like this column values are present , so write a sql query to select all rows which have column value in this format , here PRF:  is constant it will never change the only changing value is that string after : symbol , can someone please help me in this .</p>