From: Mladen Gogala <gogala.mladen@gmail.com>
To: Prashant Kulkarni <ppk10.prashant@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: How to Export Import particular/selected tables using PG Admin tool
Date: Tue, 21 Sep 2021 10:05:01 -0400
Message-ID: <f6e869c2-68f0-8abe-08d1-e4e15b636369@gmail.com> (raw)
In-Reply-To: <CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com>
References: <CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gogala.mladen@gmail.com, ppk10.prashant@gmail.com
Subject: Re: How to Export Import particular/selected tables using PG Admin tool
In-Reply-To: <f6e869c2-68f0-8abe-08d1-e4e15b636369@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox