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
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
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