Repository navigation
Add domain support #434
Description
A domain is "essentially a data type with optional constraints". You can think of them as type aliases. By using a domain, you can easily create custom types. For example, here's how you could create a KSUID type.
CREATE DOMAIN ksuid AS VARCHAR(27) NOT NULL;
CREATE TABLE foo (
id ksuid PRIMARY KEY,
created_at TIMESTAMP DEFAULT NOW()
);
CREATE TABLE bar (
id ksuid PRIMARY KEY,
created_at TIMESTAMP DEFAULT NOW(),
foo_id ksuid REFERENCES foo(id),
name text NOT NULL,
slug text NOT NULL UNIQUE
);The advantage to using a domain is that you'd only need one entry in overrides
overrides:
- db_type: "ksuid"
go_type: "github.com/segmentio/ksuid.KSUID"Replaces #418
Activity
stepan-romankov commentedon Jul 12, 2023
This looks to be supported, except schema scoped domain types like
CREATE DOMAIN public.name TEXT NOT NULL;hectorj-thetreep commentedon Dec 8, 2023
It seems to work too, you just have to include the scope in the
db_type