have postgres only store unique values code example

Example: psql select unique

SELECT
   DISTINCT column1
FROM
   table_name;