resource "postgresql_schema" "public" {
  name          = "public"
  database      = postgresql_database.main.name
  owner         = postgresql_role.main_owner.name
  if_not_exists = true
  drop_cascade  = false
}

resource "postgresql_schema" "dna" {
  name          = "dna"
  database      = postgresql_database.main.name
  owner         = postgresql_role.main_owner.name
  if_not_exists = true
  drop_cascade  = false
}

resource "postgresql_schema" "aws_s3" {
  name          = "aws_s3"
  database      = postgresql_database.main.name
  owner         = "rds_superuser"
  if_not_exists = true
  drop_cascade  = false

  depends_on = [postgresql_extension.aws_s3]
}