Pg_full_text

MIster jashon

27 min read

·

Oct 05, 2024

12

Share

Understanding and Utilizing pg_full_text for Powerful Text Search in PostgreSQL

Are you tired of the limitations of the standard LIKE operator when it comes to searching for text within your PostgreSQL database? Do you need a more robust and flexible solution for complex text searches? Then pg_full_text might be the answer you've been looking for!

pg_full_text is a powerful PostgreSQL extension that provides a full-text search capability, allowing you to efficiently search for specific words, phrases, and even patterns within your database. It goes beyond the simple matching capabilities of LIKE, offering features like stemming, stop-word removal, and ranking, making it ideal for applications like search engines, document management systems, and more.

What makes pg_full_text special?

Unlike the built-in text search capabilities of PostgreSQL, pg_full_text offers several advantages:

• Enhanced search functionality: It allows you to search for specific words, phrases, and even complex patterns within your data.
• Stemming and stop-word removal: pg_full_text automatically processes your search terms, removing common words (stop words) and finding variations of your search terms through stemming, leading to more comprehensive results.
• Ranking and relevancy scoring: It provides a ranking mechanism, letting you retrieve the most relevant results based on the search terms.
• Flexibility and customization: pg_full_text offers various options for customization, allowing you to fine-tune the search behavior to meet your specific needs.

Getting started with pg_full_text

Before you can start utilizing the power of pg_full_text, you need to install it. This process is straightforward:

1. Install the pg_full_text extension: Use the CREATE EXTENSION command to install the extension:

   CREATE EXTENSION pg_full_text;
   

2. Create a full-text index: After installing the extension, you need to create a full-text index on the column(s) you want to search. For example:

   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;
   CREATE EXTENSION pg_full_text;
   CREATE EXTENSION pg_trgm;