I have a table named product which contains two columns:

id  name
1   p1
2   p2
3   p1
4   p3
5   p4

I run the following query:

SELECT DISTINCT id, name FROM product;

As a result, PostgreSQL gives me the following output:

id  name
1   p1
2   p2
3   p1
4   p3
5   p4

I want to avoid duplication of values in the name field, so the desired output should look like this:

1   p1
2   p2
4   p3
5   p4

How should I go about achieving this?