Jim Buttafuoco mentioned :
=> I use dblink to attach to both databases and query pg_namespace, pg_class,
pg_attribute ... to get the diffs. See
=> attached as an example. look for the dblink_connect lines to specify your
database. You will need to install
=> contrib/dblink. I used this with 7.4.X series and have NOT tested yet with
8.0.X.
Thanks!
This is something I haven't even thought of.
Only some of the machines have dblink installed at the moment,
but that's the same work as having to install pgcrypto everywhere.
This is actually more thorough. It seems to be working with some minor changes
on 7.3
(The dblink functions don't allow multiple connections, and take only one
argument, so
I created temp tables in stead). This is actually very fast.
Thanks again.
Kind Regards
Stefan
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
