Analyze. Act. Achieve.
Kurinchilion KURINCHILION Analyze. Act. Achieve.

News

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";