title: How to create n-gram in postgresql
body: <p>I want search functionality in my application.</p>
  
  <p>I used trigram for achieving it and it is working fine.</p>
  
  <p><strong>Problem is:</strong></p>
  
  <p>trigram is creating sequence of 3 character group of word.
  I want more than 3 character in single object.
  For Example:</p>
  
  <pre><code>select show_trgm('abcpqrs');
  </code></pre>
  
  <p>This will return: <code>{"  a"," ab","abc","bcp","cpq","pqr","qrs","rs "}</code></p>
  
  <p>I want <code>{"  a"," ab","abc","bcp","cpq","pqr","qrs","rs ","abcd","bcpq","cpqr"...}</code></p>
  
  <p>How can I achieve this?</p>