comparing table structure

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sangeetha m
    New Member
    • Oct 2011
    • 1
    #1

    comparing table structure

    dump old and new table structures and search for differences... especially in the INDEXes.

    Is there any command/script to do the comparision?
    Tags: None
    • rski
      Recognized Expert Contributor
      • Dec 2006
      • 700
      #2
      What about \d command, you can use it in psql
      Code:
      \d old_table
\d new_table
      Isn't it enough for you?

        Comment

        Previous template Next
        Working...