insert.txt

INSERT INTO customers (name, email, created_by)
VALUES ('John Doe', 'john.doe@example.com', ROW('namespace1', '12345'));

table.sql

CREATE TYPE urn AS (
    namespace TEXT,
    identifier TEXT
);

CREATE TABLE customers (
    customer_id SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE NOT NULL,
    created_by urn, -- Using the custom "urn" type
    created_at TIMESTAMP DEFAULT NOW()
);