title: Synonym support on PostgreSQL
body: <p>How to create and use Synonyms on PostgreSQL as in Oracle. Do I need to create some DB link or any thing else. I could not find any good official doc on this topic.</p>
  
  <p><strong>Edit 1</strong></p>
  
  <p>Actually as of now i have an application which has two separate modules which connects with two different oracle databases; One modules need to access tables of other so for which we use synonyms over db link in oracle. Now we are migrating application to postgresql, so we need synonyms.</p>
  
  <p><strong>Edit 2</strong>
  When i say two different oracle databases it means it can be two different oracle instances or two schemas of same db, it is configurable in application and application must support both modes.</p>
  
  <p>PostgreSQL version: 9.6.3 </p>