how to add the new column in the existing data

[Boby900]

I want to add a new column in the existing data, but every time I try to do that I get a new error.
I also don't want to delete my whole data and start from scratch,
is there any way to add new column may be fill it with some default data to not have null values and then start populating the data along with other columns simultaneously.

TIA

[oluwaseun-demonflowne]

please where you able to solve this ? i’m having this same issue

[Boby900]

I guess they have fixed it, you can ask this in their discord channel.
I had dropped my project at that time

[nicholasdly]

@oluwaseun-demonflowne Check out my most recent response!

[nicholasdly]

You can use the default clause to populate the new non-nullable column with a default value.

export const users = pgTable("users", {
  id: uuid().primaryKey(),
  githubId: integer().notNull().default(0), // new
});

If you need the default value to be some dynamic value, you can use $default or $defaultFn.

function getRandomInt(max: number) {
  return Math.floor(Math.random() * max);
}

export const users = pgTable("users", {
  id: uuid().primaryKey(),
  githubId: integer().notNull().$default(() => getRandomInt(100)), // new
});

[jacksonsophat]

It doesn't work. This will create new random number for the next insert data but not updating the existing data. Is that right?

[Boby900]

I guess if you will create a new column in the existing table so it will be populated with the null constraint, so it should not throw any errors