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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
