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