pg-diff
pg-diff copied to clipboard
How to generate separate scripts for Functions only and Tables Only
Is there a way to generate a separate scripts for the functions and tables. And also how can we ignore onwers while generating the script.
Hi @syed-shajjath ,
The idea behind this tool is the ATOMICITY of the differences between two databases, I don't get the need to create two different scripts, but if you can supply me with more details about your needs I will do my best to follow you 😄 .
The owner of an object is very important in terms of DIFFERENCES between two databases and in terms of "replicate" security behaviors; but theoretically yes, it can be an option to exclude the OWNERSHIP STATEMENT.