Fork me on GitHub
#sql
<
2024-02-09
>
isak16:02:01

Anyone know of something like pg_dump --schema-only, except less spammy? E.g., no repeating of settings that are default, and using standard abbreviations (e.g., 'timestamptz' instead of 'timestamp with time zone'). Basically closer to what a reasonable person would write for the DDL.

respatialized18:02:40

https://github.com/camsaul/sqlhoney You could try parsing the DDL into HoneySQL and use Clojure to condense and filter it

isak18:02:37

Looks like that only supports queries, not DDL, but that is a cool project