On Tue, Aug 30, 2011 at 3:14 PM, Joe Abbate <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
