Re: How to Export Import particular/selected tables using PG Admin tool

Mladen Gogala <gogala.mladen@xxxxxxxxx> · Tue, 21 Sep 2021 10:05:01 -0400



    On 9/21/21 08:52, Prashant Kulkarni
      wrote:

    
        Hi All,
        

        Please can you help me how we can export/import particular
          tables using PGAdmin tool.
        I did not find any option to export/import only required
          tables using PGAdmin tool.
        

        PG admin has an option to export/import tables in csv and
          using backup/restore option but we can export/import only one
          table at a time using these functionalities which is not
          feasible. 

        
        For instance: 

        
        We have a scenario where we have to export and import only
          60 tables from a schema having thousands of tables in it. We
          can not export/import the tables one by one using the option
          available in the PG admin tool.

        
        OR
        

        Is there any other GUI tool available which has this
          functionality to export/import particular tables.
        

        Kindly let me know !!

        
        Thanks,

        
    When you right click on the database name, one of the options is
      "backup". That is pg_dump. As for the other GUI tools, there are
      many: Commvault, Veeam and Rubrik among others. I prefer
      Commvault.
    Regards

    
    -- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com