title: Is this possible to make database changes for two same posgres database within same server at same time?
body: <p>I am using PGAdmin UI for Postgresql.</p>
  
  <p>I have two database '<strong>demo</strong>' and '<strong>testing</strong>'(for testing) and  both database has same  schema and data.when there is any changes in database I have repeat all process for both database.for example if data type of column change i have to run this query script for both.</p>
  
  <p>Is there any work around in postgres that I made any changes in first("demo") database will reflect in other ("testing") database.</p>
  
  <p>I think there is 'template1' template which store all database changes and object as per my knowledge.</p>
  
  <p>using this can I achieve this ? or Is there any other way to do this?</p>
  
  <p>thanks in advance !</p>