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