Teemu Juntunen wrote:
> 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?
Use the information_schema, see
http://www.postgresql.org/docs/current/static/information-schema.html
There is a view called "triggers" that will be useful.
Yours,
Laurenz Albe