matthewmueller/index.js

## 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

      
    Raw
  

              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
	// 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
	}