How to version control PostgreSQL schema with comments?
9
votes
4
answers
4679
views
I version control most of my work with Git : code, documentation, system configuration.
I am able to do that because all my valuable work is stored as text files.
I have also been writing and dealing with lot of SQL schema for our Postgres database. The schema includes views, SQL functions, and we will be writing Postgres functions in R programing language (via PL/R ).
I was trying to copy and past the chunks schema that I and my collaborators write but I forget to do that. The copy and past action is repetitive and error prone.
The pg_dump / pg_restore method will not work because it looses comments.
Ideally I would like to have some way to extract my current schema into a file or files and preserve the comments so that I can do version control.
What is the best practice to version control schema with comments?
Asked by Aleksandr Levchuk
(1227 rep)
Feb 27, 2011, 07:23 AM
Last activity: Jan 9, 2019, 12:37 AM
Last activity: Jan 9, 2019, 12:37 AM