[Feature Request] When changing owner of database, change ownership of all objects by providing an additional flag

[lukaalba]

Hi there,

I would like to request an additional flag for the postgresql_database-resource. Although it is possible to change the owner of the database itself with this resource, the owner of already created tables or sequences in this database is not altered. I would like to suggest an additional flag to be able to alter those objects, too, e.g.:

Terraform Configuration Files

resource "postgresql_database" "my_db" {
  name              = "my_db"
  owner             = "my_role"
  template          = "template0"
  lc_collate        = "C"
  connection_limit  = -1
  allow_connections = true
  alter_object_ownership = true
}

If this feature request turns out to be useful, I am happy to provide a PR.

[melihsunbul]

Hi, it would be actually quite helpful.