Hi there, quick question that i couldn't find a so...
# getting-started
f
Hi there, quick question that i couldn't find a solution for. I'm using Meltano+DBT with a postgres target. Is there a way to set the LC_COLLATION of the database that meltano creates? I need it to be C.UTF-8 or de_AT.UTF-8 in order to use some unicode features ( like initcap ). Unfortunately I haven't found anything in the target-postgres configuration 😞
I mean "LC_COLLATE" of course
s
@felix_klein just to get my facts right: Isn't that a postgres database level option? (One that cannot be changed afterwards) How come Meltano creates a database? Shouldn't it just create a schema for you?
f
oh god i'm stupid
yes you're right, meltano creates the Tables not the db
I may need more sleep 😉 thanks anyway!