index.js

// Usage:
// $ node index.js
// 
// Code to generate this. Should be modified to auto-generate tables, columns, etc.


const types = [
  'bigint',
  'int8',
  'bigserial',
  'serial8',
  'bit',
  'bit(1)',
  'bit(10)',
  'bit varying',
  'bit varying(1)',
  'bit varying(10)',
  'varbit',
  'varbit(1)',
  'varbit(10)',
  'boolean',
  'bool',
  'box',
  'bytea',
  'character',
  'character(1)',
  'character(10)',
  'char',
  'char(1)',
  'char(10)',
  'character varying',
  'character varying(1)',
  'character varying(110)',
  'varchar',
  'varchar(1)',
  'varchar(110)',
  'cidr',
  'circle',
  'date',
  'double precision',
  'float8',
  'inet',
  'integer',
  'int',
  'int4',
  'interval',
  'interval year',
  'interval day to hour',
  'interval day to second',
  'interval day to second(0)',
  'interval day to second(6)',
  'interval(0)',
  'interval(6)',
  'json',
  'jsonb',
  'line',
  'lseg',
  'macaddr',
  'money',
  'numeric(7,5)',
  'numeric(10,5)',
  'decimal',
  'decimal(7,5)',
  'decimal(10,5)',
  'path',
  'pg_lsn',
  'point',
  'polygon',
  'real',
  'float4',
  'smallint',
  'int2',
  'smallserial',
  'serial2',
  'serial',
  'serial4',
  'text',
  'time',
  'time(10)',
  'time(1)',
  'time without time zone',
  'time (10) without time zone',
  'time (1) without time zone',
  'time with time zone',
  'time (10) with time zone',
  'time (1) with time zone',
  'timestamp without time zone',
  'timestamp (10) without time zone',
  'timestamp (1) without time zone',
  'timestamp with time zone',
  'timestamp (10) with time zone',
  'timestamp (1) with time zone',
  'tsquery',
  'tsvector',
  'txid_snapshot',
  'uuid',
  'xml',
  'bigint[]',
  'int8[]',
  'bit[]',
  'bit(1)[]',
  'bit(10)[]',
  'bit varying[]',
  'bit varying(1)[]',
  'bit varying(10)[]',
  'varbit[]',
  'varbit(1)[]',
  'varbit(10)[]',
  'boolean[]',
  'bool[]',
  'box[]',
  'bytea[]',
  'character[]',
  'character(1)[]',
  'character(10)[]',
  'char[]',
  'char(1)[]',
  'char(10)[]',
  'character varying[]',
  'character varying(1)[]',
  'character varying(110)[]',
  'varchar[]',
  'varchar(1)[]',
  'varchar(110)[]',
  'cidr[]',
  'circle[]',
  'date[]',
  'double precision[]',
  'float8[]',
  'inet[]',
  'integer[]',
  'int[]',
  'int4[]',
  'interval[]',
  'interval year[]',
  'interval day to hour[]',
  'interval day to second[]',
  'interval day to second(0)[]',
  'interval day to second(6)[]',
  'interval(0)[]',
  'interval(6)[]',
  'json[]',
  'jsonb[]',
  'line[]',
  'lseg[]',
  'macaddr[]',
  'money[]',
  'numeric(7,5)[]',
  'numeric(10,5)[]',
  'decimal[]',
  'decimal(7,5)[]',
  'decimal(10,5)[]',
  'path[]',
  'pg_lsn[]',
  'point[]',
  'polygon[]',
  'real[]',
  'float4[]',
  'smallint[]',
  'int2[]',
  'text[]',
  'time[]',
  'time(10)[]',
  'time(1)[]',
  'time without time zone[]',
  'time (10) without time zone[]',
  'time (1) without time zone[]',
  'time with time zone[]',
  'time (10) with time zone[]',
  'time (1) with time zone[]',
  'timestamp without time zone[]',
  'timestamp (10) without time zone[]',
  'timestamp (1) without time zone[]',
  'timestamp with time zone[]',
  'timestamp (10) with time zone[]',
  'timestamp (1) with time zone[]',
  'tsquery[]',
  'tsvector[]',
  'txid_snapshot[]',
  'uuid[]',
  'xml[]',
]

const attrs = combos(['primary key', 'unique', 'default', 'not null'])

for (let i = 0; i < types.length; i++) {
  console.log(`- [ ] ${types[i]}`)
  for (let j = 0; j < attrs.length; j++) {
    if (!attrs[j].length) {
      console.log(`  - [ ] *(no attributes)*`)
      continue
    }
    console.log(`  - [ ] ${attrs[j].join(' ')}`)
  }
}

function combos(array) {
  const results = [[]]
  for (const value of array) {
    const copy = [...results] // See note below.
    for (const prefix of copy) {
      results.push(prefix.concat(value))
    }
  }
  return results
}

postgres-checklist.md

• bigint
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int8
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bigserial
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• serial8
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit(10)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit varying
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit varying(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit varying(10)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varbit
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varbit(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varbit(10)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• boolean
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bool
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• box
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bytea
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character(10)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• char
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• char(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• char(10)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character varying
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character varying(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character varying(110)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varchar
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varchar(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varchar(110)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• cidr
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• circle
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• date
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• double precision
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• float8
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• inet
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• integer
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int4
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval year
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to hour
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to second
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to second(0)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to second(6)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval(0)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval(6)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• json
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• jsonb
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• line
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• lseg
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• macaddr
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• money
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• numeric(7,5)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• numeric(10,5)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• decimal
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• decimal(7,5)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• decimal(10,5)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• path
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• pg_lsn
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• point
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• polygon
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• real
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• float4
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• smallint
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int2
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• smallserial
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• serial2
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• serial
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• serial4
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• text
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time(10)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time(1)
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time without time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (10) without time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (1) without time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time with time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (10) with time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (1) with time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp without time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (10) without time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (1) without time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp with time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (10) with time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (1) with time zone
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• tsquery
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• tsvector
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• txid_snapshot
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• uuid
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• xml
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bigint[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int8[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit(10)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit varying[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit varying(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bit varying(10)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varbit[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varbit(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varbit(10)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• boolean[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bool[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• box[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• bytea[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character(10)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• char[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• char(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• char(10)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character varying[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character varying(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• character varying(110)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varchar[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varchar(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• varchar(110)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• cidr[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• circle[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• date[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• double precision[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• float8[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• inet[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• integer[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int4[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval year[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to hour[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to second[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to second(0)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval day to second(6)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval(0)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• interval(6)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• json[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• jsonb[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• line[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• lseg[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• macaddr[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• money[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• numeric(7,5)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• numeric(10,5)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• decimal[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• decimal(7,5)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• decimal(10,5)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• path[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• pg_lsn[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• point[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• polygon[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• real[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• float4[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• smallint[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• int2[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• text[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time(10)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time(1)[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time without time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (10) without time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (1) without time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time with time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (10) with time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• time (1) with time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp without time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (10) without time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (1) without time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp with time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (10) with time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• timestamp (1) with time zone[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• tsquery[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• tsvector[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• txid_snapshot[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• uuid[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null
• xml[]
  • (no attributes)
  • primary key
  • unique
  • primary key unique
  • default
  • primary key default
  • unique default
  • primary key unique default
  • not null
  • primary key not null
  • unique not null
  • primary key unique not null
  • default not null
  • primary key default not null
  • unique default not null
  • primary key unique default not null