Re: [ADMIN] Diffs between two databases...

2005-11-18 Thread Alvaro Herrera
Mario Splivalo wrote: > I've seen that I can do pg_dump to a file with pg_dump -Fc, and then I > can do pg_restore -Fc -l to have the list of all the > database objects. There I can see the functions, but how do I (re)create > just the desired function? Use pg_restore -L. > What would suit me t

[ADMIN] Diffs between two databases...

2005-11-18 Thread Mario Splivalo
I have a production server (7.4.9) with, of course, a production database with 30 tables, 250 functions, types, views, indices, ... My developers have created new version of the software, that includes the new version of the datbase. They've changed 6 tables, two dozen views and almost one hundred