While i am trying to insert string into UUID column in postgre, i am facing the following error

ERROR: column "id" is of type uuid but expression is of type character varying
Hint: You will need to rewrite or cast the expression.

How do i insert UUID in postgres?

Where in Pentaho forums i see it as to change option in Database settings. where to find Database settings?


Thanks,
Hemanth