PostgreSQL's collation-provider abstraction — the 3-way split between builtin (PG-owned), icu (ICU library), and libc (OS-provided). Covers src/backend/utils/adt/pglocale.c (the dispatcher) + pglocalebuiltin.c / pglocaleicu.c / pglocalelibc.c (per-provider implementations) plus the encoding conversion layer (src/backend/utils/mb/). Loads when the user asks about CREATE COLLATION, provider semantics, LCCOLLATE / LCCTYPE, ICU integration + version tracking, the builtin provider added PG 17, collversion upgrade detection, why an ORDER BY differs between PGs on the same OS, pgcutf8 builtin, or multibyte encoding conversion. Skip when the ask is about client encoding (server-client convert is included but psql \encoding is client-side), full-text search dictionaries (different subsystem tsearch), or CREATE TEXT SEARCH CONFIGURATION.
Install with
Claude CodeCodexCursorGitHub CopilotGemini CLI
Supported by the Atlas install prompt. Skill-specific requirements vary.
Skill stats
Skills1CategoryGrowth & marketingStars0
About this skill
PostgreSQL's collation-provider abstraction — the 3-way split between builtin (PG-owned), icu (ICU library), and libc (OS-provided). Covers src/backend/utils/adt/pglocale.c (the dispatcher) + pglocalebuiltin.c / pglocaleicu.c / pglocalelibc.c (per-provider implementations) plus the encoding conversion layer (src/backend/utils/mb/). Loads when the user asks about CREATE COLLATION, provider semantics, LCCOLLATE / LCCTYPE, ICU integration + version tracking, the builtin provider added PG 17, collversion upgrade detection, why an ORDER BY differs between PGs on the same OS, pgcutf8 builtin, or multibyte encoding conversion. Skip when the ask is about client encoding (server-client convert is included but psql \encoding is client-side), full-text search dictionaries (different subsystem tsearch), or CREATE TEXT SEARCH CONFIGURATION.
Quick start
Copy the install prompt. Use the green button above this README.
Send it to your agent. Paste it into your coding agent’s chat and send.
Review the setup. Your agent checks the skill’s instructions, requirements, and installation scope.
PostgreSQL's collation-provider abstraction — the 3-way split between `builtin` (PG-owned), `icu` (ICU library), and `libc` (OS-provided). Covers `src/backend/utils/adt/pg_locale.c` (the dispatcher) + `pg_locale_builtin.c` / `pg_locale_icu.c` / `pg_locale_libc.c` (per-provider implementations) plus the encoding conversion layer (`src/backend/utils/mb/`). Loads when the user asks about `CREATE COLLATION`, provider semantics, `LC_COLLATE` / `LC_CTYPE`, ICU integration + version tracking, the `builtin` provider added PG 17, `collversion` upgrade detection, why an ORDER BY differs between PGs on the same OS, `pg_c_utf8` builtin, or multibyte encoding conversion. Skip when the ask is about client encoding (server-client convert is included but psql `\encoding` is client-side), full-text search dictionaries (different subsystem `tsearch`), or `CREATE TEXT SEARCH CONFIGURATION`.
About this listing
Category
Growth & marketing
Reported license
PostgreSQL
Listing language (estimated)
English
Review status
Not individually reviewed
Agent compatibility
Atlas installation supports Claude Code, Codex, and Cursor. Skill-specific dependencies and features are checked during setup.
Claude Code
Codex
Cursor
GitHub Copilot
Gemini CLI