title: postgresql calling column with same name
body: <p>I have two tables, where they have the same ID name (I cannot change the way the tables are designed) and I'm trying to query table2's ID, how would I do this when they are joined?</p>
  
  <pre><code>create table table1(
      id          integer, -- PG: serial
      description MediumString not null,
      primary key (id)
  );
  
  
  create table table2 (
      id          integer, -- PG: serial
      tid         references table1(id),
      primary key (id)
  );
  </code></pre>
  
  <p>So basically when they're joined, two columns will have the same name "id" if I do the following query</p>
  
  <pre><code>select * from table1
  join table2 on table1.id = table2.tid;
  </code></pre>