How to find duplicate records in PostgreSQL?

I have a PostgreSQL database table called "user_links" which currently allows the following duplicate fields: year,...

Oracle Equivalent to MySQL INSERT IGNORE??

I need to update a query so that it checks that a duplicate entry does not exist before insertion. In MySQL I can j...