PostgreSQL Schema Dump Sanitiser

This go library serves to produce a more human readable schema dump by cleaning up the output from PostgreSQL's pg_dump -s command.

The library was last updated with PostgreSQL 11.

Setup

go get -u github.com/jchiam/psql-schema-dump-sanitiser

Linting

go get -u github.com/golang/lint/golint
golint <path>

Tests

go test <path>

Usage

Run from your $GOPATH:

psql-schema-dump-sanitiser <input path> > <output path>

Outstanding Issues

• Produced output does not print tables in referential order #1
• Add tests #2

Specifications

The processing mechanism is as follows.

1. Redunant lines such as comments, SET , EXTENSIONS and OWNER statements are removed
2. CREATE TABLE statements are parsed into table maps containing column information
3. Any multi-line statements are squashed into single line statements
4. Sequences are parsed and process through the following
   1. Modifiers with default values are removed for CREATE SEQUENCE statements
   2. CREATE SEQUENCE and ALTER SEQUENCE statements are mapped respectively to their tables
5. Default values are added to the table columns
6. Constraint statements are mapped to tables and columns are marked as primary key or foreign key
7. Indices statements are mapped to tables
8. If there are anymore unprocessed lines, fatal error occurs
9. Print output (tables are printed in topological order to ensure referential integrity when dumping into database)