I need to automate comparison of schemas between DBs.
I've found that pg_dump produces different order of tables etc.. so can't directly compare that
but on the other hand I see pgAdmin brings up really neat syntax (and different from pg_dump)
Could you guys disclose if the logic to get SQL for a table is custom programmed by pgAdmin or uses some some built-in postgres DB functionality and only displays it's output back?