Unable to specify PostgreSQL schema when calling schema.alterTable

[hannesj]

When calling db.schema.alterTable, it is not possible to give it a table name with a postgres schema name. This is possible in db.schema.createTable and db.schema.dropTable, as they call parseTable, when creating the node, which returns the table identifier separated in schema and table names

typescript:

db.schema
    .alterTable("schema.table")
    .addColumn("started_at", "timestamptz")
    .execute()

sql:

alter table "schema.table" add column "started_at" timestamptz

sql should be:

alter table "schema"."table" add column "started_at" timestamptz

[koskimas]

Hey, thanks for reporting this! We'll fix this ASAP. In the meantime, you should be able to do this:

db.schema
    .withSchema("schema")
    .alterTable("table")
    .addColumn("started_at", "timestamptz")
    .execute()

[hannesj]

Hi, took a stab in fixing it in #471