Content-Type: multipart/alternative;
 boundary="------------xkJW0uwRHeMRojNpsM9OYl2Y"
Message-ID: <f6e869c2-68f0-8abe-08d1-e4e15b636369@gmail.com>
Date: Tue, 21 Sep 2021 10:05:01 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.1.0
Subject: Re: How to Export Import particular/selected tables using PG Admin
 tool
Content-Language: en-US
To: Prashant Kulkarni <ppk10.prashant@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
References: 
 <CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: 
 <CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/f6e869c2-68f0-8abe-08d1-e4e15b636369%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------xkJW0uwRHeMRojNpsM9OYl2Y
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


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

--------------xkJW0uwRHeMRojNpsM9OYl2Y
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p><br>
    </p>
    <div class="moz-cite-prefix">On 9/21/21 08:52, Prashant Kulkarni
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Hi All,</div>
        <div><br>
        </div>
        <div>Please can you help me how we can export/import particular
          tables using PGAdmin tool.</div>
        <div>I did not find any option to export/import only required
          tables using PGAdmin tool.</div>
        <div><br>
        </div>
        <div>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. <br>
        </div>
        <div><br>
        </div>
        <div><b>For instance:</b> <br>
        </div>
        <div>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.<br>
        </div>
        <div><br>
        </div>
        <div><b>OR</b></div>
        <div><b><br>
          </b></div>
        <div>Is there any other GUI tool available which has this
          functionality to export/import particular tables.</div>
        <div><br>
        </div>
        <div>Kindly let me know !!<br>
        </div>
        <div><br>
        </div>
        <div>Thanks,<br>
        </div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>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.</p>
    <p>Regards<br>
    </p>
    <p><br>
    </p>
    <p><br>
    </p>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>
--------------xkJW0uwRHeMRojNpsM9OYl2Y--