PostgreSQL: uuid_generate fails

i) If you are using pgadmin or any other psql client, make sure that the path to psql bin directory is correctly set under the client's preference In pgAdmin4, it is File > Preference > Path > Binary Path ii) Execute the below command if the extension is available but is not installed db=# > \c <DATABASE> db=# > CREATE EXTENSION IF NOT EXISTS "uuid-ossp";