monolayer-pg / schema / characterVarying

Function: characterVarying()

characterVarying(maximumLength?): PgCharacterVarying

Column that stores variable-length string with an optional maximum length.

Parameters

Parameter	Type	Description
maximumLength?	number	Maximum character length of strings in the column. Must be greater than zero and cannot exceed 10,485,760.

Returns

PgCharacterVarying

Remarks

Without a maximumLength specified, the column accepts strings of any length. In any case, the longest possible character string that can be stored is about 1 GB.

Kysely database schema type definition

{
  readonly __select__: string | null;
  readonly __insert__: string | null | undefined;
  readonly __update__: string | null;
};

Nullability and optionality will change according to the column's constraints, generated values, and default data values.

Example

import { characteVarying, schema, table } from "@monolayer/pg/schema";

const dbSchema = schema({
  tables: {
    example: table({
      columns: {
        name: characteVarying(),
      },
    }),
  },
});

// Kysely database schema type
type DB = typeof dbSchema.infer;

See

PostgreSQL Docs: character varying