EctoDBScanner.EnumDetector (EctoDBScanner v0.3.0)

Copy Markdown View Source

Detects enum-like columns via PostgreSQL ENUM types and heuristic analysis.

Summary

Functions

Detects enum-like string columns using cardinality heuristics. Returns %{{schema, table, column} => ["val1", "val2", ...]}.

Queries pg_type/pg_enum catalogs for all defined PostgreSQL ENUM types. Returns %{"type_name" => ["val1", "val2", ...]}.

Functions

detect_heuristic_enums(repo, tables_with_counts, columns, pool_size)

Detects enum-like string columns using cardinality heuristics. Returns %{{schema, table, column} => ["val1", "val2", ...]}.

query_pg_enums(repo)

Queries pg_type/pg_enum catalogs for all defined PostgreSQL ENUM types. Returns %{"type_name" => ["val1", "val2", ...]}.