pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to Export Import particular/selected tables using PG Admin tool
5+ messages / 4 participants
[nested] [flat]
* How to Export Import particular/selected tables using PG Admin tool
@ 2021-09-21 12:52 Prashant Kulkarni <ppk10.prashant@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Prashant Kulkarni @ 2021-09-21 12:52 UTC (permalink / raw)
To: pgsql-admin
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,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to Export Import particular/selected tables using PG Admin tool
@ 2021-09-21 14:05 Mladen Gogala <gogala.mladen@gmail.com>
parent: Prashant Kulkarni <ppk10.prashant@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Mladen Gogala @ 2021-09-21 14:05 UTC (permalink / raw)
To: Prashant Kulkarni <ppk10.prashant@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: How to Export Import particular/selected tables using PG Admin tool
@ 2021-09-21 16:33 dave@davebolt.co.uk
parent: Prashant Kulkarni <ppk10.prashant@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: dave@davebolt.co.uk @ 2021-09-21 16:33 UTC (permalink / raw)
To: 'Prashant Kulkarni' <ppk10.prashant@gmail.com>; pgsql-admin
Hi Prashant,
I just tried what you want in phpPgAdmin. Worked fine.
Select the Schema you want to work with, for example public, on the left.
You should get a list of tables on the right, with checkboxes.
Check all the tables you want to work with.
Now Click on the Export option, always shows top right for me.
Select what you want to do, export data, structure or both, and the format you want to use, Copy or SQL, then the radio button for Show, Download or Download Compressed, and finally click the Export button.
Regards
Dave
From: Prashant Kulkarni [mailto:ppk10.prashant@gmail.com]
Sent: 21 September 2021 13:53
To: pgsql-admin
Subject: How to Export Import particular/selected tables using PG Admin tool
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,
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to Export Import particular/selected tables using PG Admin tool
@ 2021-09-22 05:08 Prashant Kulkarni <ppk10.prashant@gmail.com>
parent: dave@davebolt.co.uk
0 siblings, 1 reply; 5+ messages in thread
From: Prashant Kulkarni @ 2021-09-22 05:08 UTC (permalink / raw)
To: dave@davebolt.co.uk; +Cc: pgsql-admin
Thank you all for the information.
However, we were looking to export particular tables using the PGAdmin
tool, but it seems PGAdmin does not provide this functionality.
PhpPgAdmin [Freeware] / Commvault [Licensed] are other tools that surely we
will explore.
On Tue, Sep 21, 2021 at 10:03 PM <dave@davebolt.co.uk> wrote:
> Hi Prashant,
>
> I just tried what you want in phpPgAdmin. Worked fine.
>
> Select the Schema you want to work with, for example public, on the left.
>
> You should get a list of tables on the right, with checkboxes.
>
> Check all the tables you want to work with.
>
> Now Click on the Export option, always shows top right for me.
>
> Select what you want to do, export data, structure or both, and the format
> you want to use, Copy or SQL, then the radio button for Show, Download or
> Download Compressed, and finally click the Export button.
> Regards
>
> Dave
>
>
>
> *From:* Prashant Kulkarni [mailto:ppk10.prashant@gmail.com]
> *Sent:* 21 September 2021 13:53
> *To:* pgsql-admin
> *Subject:* How to Export Import particular/selected tables using PG Admin
> tool
>
>
>
> 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,
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to Export Import particular/selected tables using PG Admin tool
@ 2021-09-22 06:38 Holger Jakobs <holger@jakobs.com>
parent: Prashant Kulkarni <ppk10.prashant@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Holger Jakobs @ 2021-09-22 06:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Am 22.09.21 um 07:08 schrieb Prashant Kulkarni:
> Thank you all for the information.
> However, we were looking to export particular tables using the PGAdmin
> tool, but it seems PGAdmin does not provide this functionality.
>
>
Asking for help regarding pgAdmin in the list of PostgreSQL server is a
bit awkward at first. pgAdmin has its own list.
But asking for a solution to a problem and limiting this to a certain
tool is another funny thing.
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-09-22 06:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-09-21 12:52 How to Export Import particular/selected tables using PG Admin tool Prashant Kulkarni <ppk10.prashant@gmail.com>
2021-09-21 14:05 ` Mladen Gogala <gogala.mladen@gmail.com>
2021-09-21 16:33 ` dave@davebolt.co.uk
2021-09-22 05:08 ` Prashant Kulkarni <ppk10.prashant@gmail.com>
2021-09-22 06:38 ` Holger Jakobs <holger@jakobs.com>
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