2 ms·
Sorry, I don't understand the question. I dump the DDL in order to save in source control. So when the same apparent structure has different DDL it causes conf
by ars 10y ago
Sorry, I don't understand the question.
I dump the DDL in order to save in source control. So when the same apparent structure has different DDL it causes confusion, especially when you have other devs, and each dumps the current DDL to save into source control.
I do pg_dump scheme -C -s > database.sql and store database.sql in source control.
> pg_dump -Fca
I would not use -a here, you should save the data and DDL together - if there is a disaster it's a lot easier to restore that way, and it doesn't cost much extra.
i.e. save DDL in source control, together with code that uses that structure.
Save both DDL, and data, in backup system.