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 😞
felix_klein
03/28/2023, 11:12 AM
I mean "LC_COLLATE" of course
s
Sven Balnojan
03/28/2023, 12:45 PM
@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
felix_klein
03/28/2023, 1:59 PM
oh god i'm stupid
felix_klein
03/28/2023, 2:00 PM
yes you're right, meltano creates the Tables not the db