Skip to content

Wrong quotation when creating a table in a schema (Postgres) #1

@ralfschulze

Description

@ralfschulze

When I define a table like this:

Table my_schema.my_table {...}

the resulting SQL is

CREATE TABLE "my_schema.my_table" ...

which creates a table with the name "my_schema.my_table", so it includes the schema name into the table name.

Correct would be:

CREATE TABLE "my_schema"."my_table" ...
dbml-tools --version
dbml-tools 0.9.1
  commit:     ffaba09
  built:      2026-05-25T15:31:43Z
  go:         go1.22.2
  platform:   linux/amd64

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions