Unquoting of DB identifiers

Hi

I noted that the DB Insert node quotes the identifiers of the query. Is there a way to make it not quote the identifiers.
Example:

-- now
insert into
    "budget"."budget_log"."ladevorgaenge"
    (
        "id"
    )
    values
    (
        '33349332-76eb-40f2-b3bf-ce1a042511a9'
    )
-- then
insert into
    budget.budget_log.ladevorgaenge
    (
        id
    )
    values
    (
        '33349332-76eb-40f2-b3bf-ce1a042511a9'
    )

Hi @Thiemo.Kellner , which db connector are you using?

If you open the advanced tab on the connector, you should find an option to delimit (by which they mean “quote”) identifiers that contain spaces:

1 Like

@takbb Thanks, I found it in the PostgreSQL connector with your help. I assumed it to be a per-statement-thing.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.