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

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