?

Log in

During DB development it became clear, that using a version control system (VCS) for sources ... - PostgreSQL [entries|archive|friends|userinfo]
PostgreSQL Users

[ website | PostgreSQL Web site ]
[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

During DB development it became clear, that using a version control system (VCS) for sources ... [Jan. 12th, 2008|08:07 pm]
PostgreSQL Users

postgresql

[poige]
... in PlPgSQL (and might be for table definitions as well) is rather highly preferable. However, I haven't found a suitable tool yet. It seems that the simpliest way is to dump a DB with Postgresql's pg_dump and then put the source under VCS, but this is poorly satisfactory. I deem the better solution would be a tool ``decomposing'' this dump into a chunk-files, containing only one function definition perhaps with other needed entities. Yeah, this is not too hard to write by myself, but if there's something better (or at least already written) available, I'd use it. :-)
linkReply

Comments:
[User Picture]From: poige
2008-01-12 09:43 pm (UTC)

> all the schemas ourselves in an editor

I wonder, are your textual sources pure SQL with main "uploader" or are they scripts uploading SQL to RDBMS by itself? One function per file or possibly/often several (related)?
(Reply) (Parent) (Thread)