gloo/pg

Postgres column types for use with gloo/migration.

Build columns with pg.column(name, type) then pass them to the migration DSL. The modifier functions (not_null, primary_key, unique, default) are re-exported here so callers only need to import gloo/pg.

Types

PgColumnType

</>

pub type PgColumnType {
  Text
  VarChar(Int)
  Integer
  BigInt
  SmallInt
  Boolean
  Timestamp
  TimestampTz
  Date
  Time
  Uuid
  Numeric(precision: Int, scale: Int)
  JsonB
  ByteA
  Serial
  BigSerial
  Real
  DoublePrecision
}

Constructors

```
Text
```
```
VarChar(Int)
```
```
Integer
```
```
BigInt
```
```
SmallInt
```
```
Boolean
```
```
Timestamp
```
```
TimestampTz
```
```
Date
```
```
Time
```
```
Uuid
```
```
Numeric(precision: Int, scale: Int)
```
```
JsonB
```
```
ByteA
```
```
Serial
```
```
BigSerial
```
```
Real
```
```
DoublePrecision
```

Values

column

</>

pub fn column(name: String, t: PgColumnType) -> migration.Column

Create a Postgres-typed column. Compile error if you pass a gloo/sqlite.SqColumnType — they are different types.

default

</>

pub fn default(
  col: migration.Column,
  expr: String,
) -> migration.Column

not_null

</>

pub fn not_null(col: migration.Column) -> migration.Column

primary_key

</>

pub fn primary_key(col: migration.Column) -> migration.Column

type_sql

</>

pub fn type_sql(t: PgColumnType) -> String

Render a Postgres column type to its DDL SQL string.

unique

</>

pub fn unique(col: migration.Column) -> migration.Column