Is it possible to force `target-postgres` to creat...
# plugins-general
j
Is it possible to force
target-postgres
to create
default_target_schema
? If I have many target environments, I do not want to create the schema manually in each of them...
a
I agree, this is a best practice for targets to implement. Which variant are you using for target-postgres?
j
Copy code
- name: target-postgres
      variant: transferwise
      pip_url: git+<https://github.com/transferwise/pipelinewise-target-postgres/@refs/pull/106/head>
Custom pip_url because there is a bug when loading result of tap-github
t
I think it will create the target schema if it doesn't exist... I don't think you need to "force" it
I just relied on that exact behavior yesterday, actually
j
ah! So maybe the only thing which does not work is auto-creation of schema where I point MELTANO_DATABASE_URI.
t
That is independent of target-postgres, I believe, yes