From: dave@davebolt.co.uk
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 17:33:15 +0100
Message-ID: <000901d7af06$60ded5c0$229c8140$@co.uk> (raw)
In-Reply-To: <CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com>
References: <CAOLrvP4NiTCH+ue0EMs98Mhn2Mvj14jmJnMw5CfHA-=jeUT09w@mail.gmail.com>
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,
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: dave@davebolt.co.uk, ppk10.prashant@gmail.com
Subject: RE: How to Export Import particular/selected tables using PG Admin tool
In-Reply-To: <000901d7af06$60ded5c0$229c8140$@co.uk>
* 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