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

resource "postgresql_schema" "workflowdb_public2" {
  name          = "public_2"
  database      = postgresql_database.main.name
  owner         = postgresql_role.workflowdb_user.name
  if_not_exists = true
  drop_cascade  = false
}

resource "postgresql_schema" "pd_etldb_public" {
  name          = "public"
  database      = postgresql_database.pd_etldb.name
  owner         = postgresql_role.pd_etldb_owner.name
  if_not_exists = true
  drop_cascade  = false
}

resource "postgresql_schema" "pd_etldb_staging" {
  name          = "staging"
  database      = postgresql_database.pd_etldb.name
  owner         = postgresql_role.pd_etldb_owner.name
  if_not_exists = true
  drop_cascade  = false
}

resource "postgresql_schema" "pd_etldb_uow_meta" {
  name          = "uow_meta"
  database      = postgresql_database.pd_etldb.name
  owner         = postgresql_role.pd_etldb_owner.name
  if_not_exists = true
  drop_cascade  = false
}