ENABLE / DISABLE ALL TRIGGERS IN DATABASE - Mailing list pgsql-general

From Teemu Juntunen
Subject ENABLE / DISABLE ALL TRIGGERS IN DATABASE
Date
Msg-id 97917F88650A4CF09BD8BF9562F3024E@eng02
Whole thread Raw
Responses Re: ENABLE / DISABLE ALL TRIGGERS IN DATABASE
Re: ENABLE / DISABLE ALL TRIGGERS IN DATABASE
List pgsql-general
Hi,
 
I think this has been asked before, but I can't find the answer from arcive nor google. How to disable/enable all the riggers in a database? I have problem with disabled triggers after database restore. If there is no simple way, could this be made in a function where you find the table names and construct the needed commands in strings. If so, how to get all the tablenames from database?
 
Best regards and thanks!
Teemu Juntunen

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Postgre connect on Postgre
Next
From: Ivan Sergio Borgonovo
Date:
Subject: update and group by/aggregate