psql distinct on code example

Example 1: postgresql distinct

SELECT
	DISTINCT bcolor
FROM
	distinct_demo
ORDER BY
	bcolor;

Example 2: psql select unique

SELECT
   DISTINCT column1
FROM
   table_name;