Re: Comparing tables in different db's

Allan Engelhardt wrote:


> (1) The output contains the OID and the owner, so I guess it won't work without stripping comments first?
> 
I was using an older version of PostgreSQL which doesn't have
the comments, and it looks like I'll need to make the OID/owner
comments an option in pg_dump, once I get the further along
in the changes I am working on.  In the mean time you can try
something like..
pg_dump -a -t table_name db1|egrep -v "\(OID|Owner" > db1_dump.out
but this is a hack to strip the offending comments, and
wouldn't work in every situation.

> (2) It (still) doesn't work if you have datetime columns with more than two digits in the miliseconds field (see
below).
> 
I'm not sure about this one, I need to do more investigation here.  BTW what platform/OS
are you using?

Darren