Skip to content

Other column data types

Column data types other than the default data types provided by monolayer-pg can be defined with the columnWithType function.

ts
const accounts = table({
  amount: columnWithType<string, string>("money"), 
});

You need specify the Select and Insert types to the function, otherwise the inferred type will be any.

WARNING

If you use Kysely as your query builder, these types should map to the types that PostgreSQL driver (node-postgres) will expect and return on queries.