Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSihy-0003Bb-8v for pgsql-admin@arkaria.postgresql.org; Tue, 21 Sep 2021 16:33:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSihw-0001BT-SO for pgsql-admin@arkaria.postgresql.org; Tue, 21 Sep 2021 16:33:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSihw-0001BL-Ck for pgsql-admin@lists.postgresql.org; Tue, 21 Sep 2021 16:33:24 +0000 Received: from nativespace-chaldene.ns-chaldene.com ([212.53.86.59]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSiht-0001Pc-E6 for pgsql-admin@postgresql.org; Tue, 21 Sep 2021 16:33:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=davebolt.co.uk; s=default; h=Content-Type:MIME-Version:Message-ID:Date: Subject:In-Reply-To:References:To:From:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date: Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id: List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=Ju3fsKSzdjAdARj6kR+PzE6kNu7QY5pKG8jBvYW37P4=; b=TxFnSIzUa5AwndadgMn5ZqvHa dQq0unkSKC5FCqOe/99V0EeLCd3yT0iJpqI9aOuw7z6l0R7H+wV7mFUcHfqVgCKGuYsGlgqr1ph04 50teINhVSOhd9V9b/P9eiT+fSntr1FHPe6gC7ii03P/7X5BYDiNNQSJup2SqmwrfkoXCg=; Received: from davebolt.plus.com ([80.229.145.181]:58044 helo=BelongadaveX) by nativespace-chaldene.ns-chaldene.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.93) (envelope-from ) id 1mSiho-000AfY-KV; Tue, 21 Sep 2021 17:33:16 +0100 From: To: "'Prashant Kulkarni'" , "'pgsql-admin'" References: In-Reply-To: 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01D7AF0E.C2A33DC0" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Adeu6Qs+1AAQw4j5QOePSwGPMG+yFwAHC67g Content-Language: en-gb X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - nativespace-chaldene.ns-chaldene.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - davebolt.co.uk X-Get-Message-Sender-Via: nativespace-chaldene.ns-chaldene.com: authenticated_id: dave@davebolt.co.uk X-Authenticated-Sender: nativespace-chaldene.ns-chaldene.com: dave@davebolt.co.uk List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_000_000A_01D7AF0E.C2A33DC0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 =20 From: Prashant Kulkarni [mailto:ppk10.prashant@gmail.com]=20 Sent: 21 September 2021 13:53 To: pgsql-admin Subject: How to Export Import particular/selected tables using PG Admin = tool =20 Hi All, =20 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. =20 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.=20 =20 For instance:=20 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. =20 OR =20 Is there any other GUI tool available which has this functionality to = export/import particular tables. =20 Kindly let me know !! =20 Thanks, ------=_NextPart_000_000A_01D7AF0E.C2A33DC0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

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,

------=_NextPart_000_000A_01D7AF0E.C2A33DC0--