Re: Comparing two PostgreSQL databases -- order of pg_dump output
| От | Jaime Casanova |
|---|---|
| Тема | Re: Comparing two PostgreSQL databases -- order of pg_dump output |
| Дата | |
| Msg-id | CAJKUy5jxJzwAGvW+5bQtjF8PSuE35X69NfTUMotZU8xs2NxV_w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Comparing two PostgreSQL databases -- order of pg_dump output (Joe Abbate <jma@freedomcircle.com>) |
| Ответы |
Re: Comparing two PostgreSQL databases -- order of pg_dump
output
|
| Список | pgsql-hackers |
On Tue, Aug 30, 2011 at 3:14 PM, Joe Abbate <jma@freedomcircle.com> wrote: > Hola Jaime, > > On 08/30/2011 03:24 PM, Jaime Casanova wrote: >> >> what about using pg_dump -Fc -Osx and use pg_restore -l to list >> objects. then you can sort and compare objects and then a script that >> compare schema of objects extracting them with -P, -T or -t > > That appears to be of limited use (i.e., it would only work for functions, > triggers and tables). pg_restore -L/--use_list is more comprehensive. > So the script would have to do something like the following: > > $ pg_dump -Fc -Osx postgis > postgis.dump > $ pg_restore -l postgis.dump | sort -k4 > postgis.list why not "sort -k4,5"? -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación
В списке pgsql-hackers по дате отправления: