Triggers when importing data

2018-11-28 Thread Sathish Kumar
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|CR

Re: Triggers when importing data

2018-11-28 Thread Laurenz Albe
Sathish Kumar wrote: > 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 > produc

Re: Triggers when importing data

2018-11-29 Thread Adrian Klaver
On 11/28/18 9:43 PM, Sathish Kumar wrote: 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. Well you command as constructed below will have no INSERTs