codechain-indexer icon indicating copy to clipboard operation
codechain-indexer copied to clipboard

Make migrations are reflected to schema-upstream.sql

Open foriequal0 opened this issue 6 years ago • 3 comments

foriequal0 avatar Nov 14 '19 06:11 foriequal0

dbdiagram.io shows me an error when I pasted the generated sql file. Do you know the way to visualize the relations? It made progress but I hope it's more easy to read.

image

joojis avatar Nov 14 '19 07:11 joojis

Oh. It'll take some time to fix that. pgformatter doesn't exist before ubuntu 19.04

foriequal0 avatar Nov 14 '19 08:11 foriequal0

dbdiagram.io doesn't seem to support full Postgres syntax. "public." prefixes are added after pg 9.4.18 https://stackoverflow.com/questions/51216297/postgresql-pg-dump-adding-public-to-all-schema-names

foriequal0 avatar Nov 26 '19 03:11 foriequal0