[Feature Request] Add comments to resources

Hello!
Is it possible to add comments to resources?

```
COMMENT ON DATABASE test
    IS 'test comment';
```

```
COMMENT ON ROLE test IS 'comment';
```

And others

### Terraform Version
```
➜  ~ terraform -v
Terraform v1.8.5
```

### Affected Resource(s)
Please list the resources as a list, for example:
- postgresql_database
- postgresql_role

