psql get unique rows code example

Example 1: mysql unique select count

SELECT COUNT(DISTINCT productId) from  table_name WHERE keyword='$keyword'

Example 2: psql select unique

SELECT
   DISTINCT column1
FROM
   table_name;