unique method postgres code example

Example: psql select unique

SELECT
   DISTINCT column1
FROM
   table_name;