Thank you everyone for your help
On Thu, 11 Jul, 2024, 1:34 am Anthony Sotolongo,
wrote:
> Hi Nikhil, maybe you can apply some tricks playing with pg_dump -s and
> pg_restore --list
>
>
> check this link: https://stackoverflow.com/a/13758324/8308381
>
>
> Regards
>
> On 10-07-24 14:05, nikhil ku
Hi Nikhil, maybe you can apply some tricks playing with pg_dump -s and
pg_restore --list
check this link: https://stackoverflow.com/a/13758324/8308381
Regards
On 10-07-24 14:05, nikhil kumar wrote:
Dear Team,
We received a request from client. They required all functions, stored
procedure
Hi Nikhil,
On Wed, Jul 10, 2024 at 8:05 PM nikhil kumar wrote:
> Dear Team,
>
> We received a request from client. They required all functions, stored
> procedures and triggers backup. can anyone please let me know. How to take
> backup only above objects.
>
>
> Thanks & Regards,
> Nikhil,
> Pos
On Wed, Jul 10, 2024 at 11:05 AM nikhil kumar
wrote:
>
> We received a request from client. They required all functions, stored
> procedures and triggers backup. can anyone please let me know. How to take
> backup only above objects.
>
This hardly qualifies as a performance question.
You might
Dear Team,
We received a request from client. They required all functions, stored
procedures and triggers backup. can anyone please let me know. How to take
backup only above objects.
Thanks & Regards,
Nikhil,
PostgreSQL DBA.
Dheeraj Sonawane writes:
> While executing the join query on the postgres database we have observed
> sometimes randomly below query is being fired which is affecting our response
> time.
> Query randomly fired in the background:-
> SELECT p.proname,p.oid FROM pg_catalog.pg_proc p, pg_catalog.p
Hello all,
While executing the join query on the postgres database we have observed
sometimes randomly below query is being fired which is affecting our response
time.
Query randomly fired in the background:-
SELECT p.proname,p.oid FROM pg_catalog.pg_proc p, pg_catalog.pg_namespace n
WHERE p.p
