Hi,
I am trying to export and import sql file of a database. I would like
to know whether it will execute all the triggers when importing the
sql dump which is for Insert or Update or Delete.
Export:pg_dump -h test -U db_admin --format=plain --no-owner --no-acl
production | sed -E 's/(DROP|CREATE|COMMENT ON) EXTENSION/-- \1
EXTENSION/g' > test.sql
Import: psql -h test -U db_admin -d production -W < test.sql