Toad World® Forums

How can one add "before" script commands

I set up a non login role to serve as a db owner say db_owner
I also assign a login user say user_! to belong to the group having access to that db_owner role.

Is there a way to add the statement
set role db_owner

when generating the ddl script?
Sure I can edit the file later, but than I have to do that after every time I generate the script.

I am wiling to accept other alternatives, for example a way to submit the script to psql by passing any other parameters dynamically.


you can put this statement to the general before script tab (menu Model | Properties...). Please, don't forget to check this property in the model generator (F9).



This was useful