Extensions (pg_trgm, uuid-ossp, hstore) in PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the pg_trgm extension in PostgreSQL?

The pg_trgm extension helps speed up text searches by breaking strings into smaller parts called trigrams, making it easier to find similar words quickly.

beginner

How does the uuid-ossp extension help in PostgreSQL?

The uuid-ossp extension provides functions to create universally unique identifiers (UUIDs), which are useful for generating unique keys that are hard to guess.

beginner

What is the hstore extension used for in PostgreSQL?

The hstore extension allows storing sets of key-value pairs within a single PostgreSQL column, useful for flexible or semi-structured data.

beginner

How do you enable the pg_trgm extension in a PostgreSQL database?

You enable it by running the SQL command: CREATE EXTENSION IF NOT EXISTS pg_trgm; inside your database.

beginner

Give an example of a function provided by the uuid-ossp extension.

One example is uuid_generate_v4(), which creates a random UUID version 4.

Which PostgreSQL extension helps speed up searches by breaking text into trigrams?

A pg_trgm

B uuid-ossp

C hstore

D postgis

The pg_trgm extension breaks text into trigrams to improve search speed.

What type of data does the hstore extension store?

A Images

B Key-value pairs

C UUIDs

D Geospatial data

Hstore stores key-value pairs inside a single column.

Which function is provided by uuid-ossp to generate a random UUID?

A uuid_generate_v1()

B uuid_make()

C uuid_create_random()

D uuid_generate_v4()

uuid_generate_v4() creates a random UUID version 4.

How do you enable an extension like pg_trgm in PostgreSQL?

A CREATE EXTENSION IF NOT EXISTS pg_trgm;

B ALTER DATABASE ADD EXTENSION pg_trgm;

C ENABLE EXTENSION pg_trgm;

D INSTALL EXTENSION pg_trgm;

You enable extensions using CREATE EXTENSION command.

Which extension would you use to generate unique identifiers for rows?

A pg_trgm

B hstore

C uuid-ossp

D citext

uuid-ossp provides functions to generate UUIDs for unique identifiers.

Explain the main uses of the PostgreSQL extensions pg_trgm, uuid-ossp, and hstore.

Think about text search, unique IDs, and flexible data storage.

Describe how to enable and use the pg_trgm extension for improving search performance.

Focus on enabling the extension and its effect on text search.