Error while creating uuid-ossp extension

Question

I am installing `uuid-ossp` extension using the following query

```sql
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
```

But I am getting the following error

```sql
ERROR:  permission denied to create extension "uuid-ossp"
HINT:  Must be superuser to create this extension.
```

Karthik Divi · Accepted Answer

As the error says give superuser permissions to your current user or try installing with superuser

## 1. Quit from current user if you are already logged in
```sql
\q
``` 
## 2. Connext with `postgres` user

```sql
psql postgres
```

## 3. Create extension

```sql
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
```

1 Answer