Given the following schema with an UNLOGGED table (docs):
CREATE UNLOGGED TABLE pgschema_unlogged_repro (
id integer PRIMARY KEY,
payload text NOT NULL
);
Running pgschema dump does not include the UNLOGGED modifier and returns an otherwise matching DDL:
CREATE TABLE IF NOT EXISTS pgschema_unlogged_repro (
id integer,
payload text NOT NULL,
CONSTRAINT pgschema_unlogged_repro_pkey PRIMARY KEY (id)
);
Given the following schema with an
UNLOGGEDtable (docs):CREATE UNLOGGED TABLE pgschema_unlogged_repro ( id integer PRIMARY KEY, payload text NOT NULL );Running
pgschema dumpdoes not include theUNLOGGEDmodifier and returns an otherwise matching DDL: