Re: Domains vs data types

Ron <ronljohnsonjr@gmail.com>

From: Ron Johnson <ronljohnsonjr@gmail.com>
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-08-20T15:43:57Z
Lists: pgsql-general
On Wed, Aug 20, 2025 at 11:05 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
[snip]

>
> Personally I don't see that integer --> aint really helps.
>

No one's going to create the domain "aint", but a DB designer in a rigorous
environment _will_ create multiple, meaningfully-named domains, all of
which happen to be INTEGER.  Makes large-team developing easier.

The alternative is Really Really Long column names, and consistent use of
agreed-upon suffixes.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!