Triggers when importing data

From: Sathish Kumar <satcse88(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Triggers when importing data
Date: 2018-11-29 05:43:04
Message-ID: CANa_DOhHkGr6HTgYXy5Qq7K1gbVS_c_id_J-BbYFHHNFFhAQag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2018-11-29 05:50:35 Re: Triggers when importing data
Previous Message Adrian Klaver 2018-11-29 05:21:44 Re: The age() of a column?