Re: Pg_restore and dump -- General question

Howard Cole <howardnews@xxxxxxxxxxxxx> · Mon, 04 Apr 2011 12:40:37 +0100



    On 04/04/2011 11:47 AM, salah jubeh wrote:
    
      
              What will happen if 

                  
                  1. dropped table a

                  2. insert data on b and the other relations

                  3. restore table a and it's dependency (table b).

                
    Simple advice would be to create a script on an offline system for
    testing - when you are happy with the results - do it on the online
    system - after making a backup of course! Anything else would be
    suicidal.