enable postgresql extension

enable-pg-ext.sh

#!/bin/bash

export PGPASSWORD="postgres" 
DB_USER="postgres"             
DB_NAME="postgres"            
DB_HOST="localhost"                
DB_PORT="5432"                    

exec_sql() {
    local sql_command="$1"
    psql -U "$DB_USER" -h "$DB_HOST" -p "$DB_PORT" -d "$DB_NAME" -t -A -c "$sql_command"
}

enable_extension() {
    local extension_name="$1"
    local extension_check

    extension_check=$(exec_sql "SELECT COUNT(*) FROM pg_extension WHERE extname = '$extension_name';")

    if [ "$extension_check" -eq 0 ]; then
        echo "Enabling $extension_name extension..."
        exec_sql "CREATE EXTENSION $extension_name;"
        echo "$extension_name extension has been enabled."
    else
        echo "$extension_name extension is already enabled."
    fi
}

enable_extension "fuzzystrmatch"
enable_extension "pg_trgm"

unset PGPASSWORD