 <p>Use <a href="http://www.postgresql.org/docs/current/static/queries-union.html" rel="nofollow">UNION</a>:</p> <pre><code>select id, name, email, phone from table1 union select id, name, email, phone from table2 union select id, name, email, phone from table3; </code></pre> <p>In the above query identical rows from different tables will be presented as one row. If you want all rows from all tables use UNION ALL.</p> <p>Use INTERSECT to select only identical rows in all three tables:</p> <pre><code>select id, name, email, phone from table1 intersect select id, name, email, phone from table2 intersect select id, name, email, phone from table3; </code></pre>