I am trying to set the default value of a column as 'Canada/Eastern' and set it to not null. Here is what the column looks like:

queryRunner.addColumn('users', new TableColumn({
    name: 'timezone_name',
    type: 'character varying',
    default: '"Canada/Eastern"',
    isNullable: false,
  }));

Its giving me an error:

query failed: ALTER TABLE "users" ADD "timezone_name" character varying NOT NULL DEFAULT "Canada/Eastern"
error: error: column "Canada/Eastern" does not exist

I am trying to set the default value of a column as 'Canada/Eastern' and set it to not null. Here is what the column looks like:

queryRunner.addColumn('users', new TableColumn({
    name: 'timezone_name',
    type: 'character varying',
    default: '"Canada/Eastern"',
    isNullable: false,
  }));

Its giving me an error:

query failed: ALTER TABLE "users" ADD "timezone_name" character varying NOT NULL DEFAULT "Canada/Eastern"
error: error: column "Canada/Eastern" does not exist

• javascript
• typescript
• postgresql
• typeorm

Share Improve this question Follow asked Nov 2, 2020 at 8:51 Mehul ChaturvediMehul Chaturvedi 6111 silver badge66 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 5

Using "'Canada/Eastern'" fixes the error

queryRunner.addColumn('users', new TableColumn({
    name: 'timezone_name',
    type: 'character varying',
    default: "'Canada/Eastern'",
    isNullable: false,
  }));

Remove isNullable and Try below code

queryRunner.addColumn('users', new TableColumn({
    name: 'timezone_name',
    type: 'character varying',
    default: '"Canada/Eastern"'
  }));