Thread: pgAdmin question
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
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.
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
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
Email: waqas.m@bitnine.net
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.