title: Is there any way to implement CI/CD for on premises Postgres SQL using Azure Devops Pipelines?
body: <p>I want to create one click deployment on azure pipelines to move Postgres Sql changes from dev to QA environment,similar to what we implement using SQL Server Database project where a Powershell script deploy the changes to the remote server.</p>
  
  <p>I have tried pg_dump and psql commands which will create dump file and restore it on the remote server. It does not perform diffing ie(comparing database changes on source and destination , and only replicating the missing changes)</p>