Torben Sorensen
ebceb0e2e3
All checks were successful
Deploy to Test Environment / deploy-to-test (push) Successful in 20m51s
25 lines
881 B
SQL
25 lines
881 B
SQL
-- sql/00-init-extensions.sql
|
|
-- ============================================================================
|
|
-- DATABASE EXTENSIONS INITIALIZATION
|
|
-- ============================================================================
|
|
-- This script is automatically run by PostgreSQL on database creation
|
|
-- when placed in /docker-entrypoint-initdb.d/
|
|
--
|
|
-- It creates the required extensions before the schema is loaded.
|
|
-- ============================================================================
|
|
|
|
-- Enable UUID generation
|
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
|
|
|
-- Enable trigram fuzzy text search
|
|
CREATE EXTENSION IF NOT EXISTS pg_trgm;
|
|
|
|
-- Enable PostGIS for geographic queries (usually pre-installed in postgis image)
|
|
CREATE EXTENSION IF NOT EXISTS postgis;
|
|
|
|
-- Log completion
|
|
DO $$
|
|
BEGIN
|
|
RAISE NOTICE '✅ All required PostgreSQL extensions have been created';
|
|
END $$;
|