Thread: pgAdmin question

pgAdmin question

From
Sbob
Date:
All;

I have a bash script that loops through all tables in the db (skipping 
the system schemas) and for each table found execuptes 3 pg_dumps to 3 
separate files:

one using --section=pre-data
one using --section=data
and one using --section=post-data


Is there a way that this could be rolled into a function and executed 
from pgadmin on a windows client?


Thanks in advance




Re: pgAdmin question

From
"David G. Johnston"
Date:
On Monday, August 12, 2024, Sbob <sbob@quadratum-braccas.com> wrote:
All;

I have a bash script that loops through all tables in the db (skipping the system schemas) and for each table found execuptes 3 pg_dumps to 3 separate files:

one using --section=pre-data
one using --section=data
and one using --section=post-data


Is there a way that this could be rolled into a function and executed from pgadmin on a windows client?


No.

David J.
 

Re: pgAdmin question

From
Sbob
Date:


On 8/12/24 4:16 PM, David G. Johnston wrote:
On Monday, August 12, 2024, Sbob <sbob@quadratum-braccas.com> wrote:
All;

I have a bash script that loops through all tables in the db (skipping the system schemas) and for each table found execuptes 3 pg_dumps to 3 separate files:

one using --section=pre-data
one using --section=data
and one using --section=post-data


Is there a way that this could be rolled into a function and executed from pgadmin on a windows client?


No.

David J.
 


I thought so, thanks


Re: pgAdmin question

From
Muhammad Waqas
Date:
I think there is no way to call utilities from database functions

You can create windows scheduler for the same

On Tue, 13 Aug 2024 at 03:05, Sbob <sbob@quadratum-braccas.com> wrote:
All;

I have a bash script that loops through all tables in the db (skipping
the system schemas) and for each table found execuptes 3 pg_dumps to 3
separate files:

one using --section=pre-data
one using --section=data
and one using --section=post-data


Is there a way that this could be rolled into a function and executed
from pgadmin on a windows client?


Thanks in advance





--
Muhammad Waqas
Senior Technical Support Engineer - Tech Support Center (Karachi)
Mobile: +92-322-2844150
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem, 
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh, 
75500 Pakistan.