Re: Comparing 2 data base or 2 tables

koff10 <koff10@xxxxxxxxxxx> · Mon, 28 Jun 2021 15:22:29 +0200



    Thanks all  for your feed back 

    @Mukesh ,    I  daily use postgres_fdw  but not   plz .   How does
    it work?

    
    Le 28/06/2021 à 14:04, Mukesh
      Rajpurohit a écrit :

    
      You may use EXCEPT keyword to compare two tables
        in two databases, plz use postgres_fdw for connectivity.
        

        Thanks
        Mukesh
      
      
        On Mon, Jun 28, 2021, 4:42 PM
          koff10 <koff10@xxxxxxxxxxx>
          wrote:

        
            Hi All,

             I am
                  in trouble with a production database.
                So, I'm looking for a script
                  or tools comparing 2 postgre database schemas 

                  and extract data differences.
                  

                I need a little help please.

                  thanks lot.

                  
                  koff Berta