how to update a column with the default value set during creation in postgres?

Asked Jun 01 '21 at 06:26

Active Jun 01 '21 at 06:29

Viewed 31 times

Is there a way to update a column to the default value given during creation. I need to do this inside a function, and was wondering if there was a way to do this in such a way that i don't have to change my code in case the default value changes later.

I am using Postgres v11

edited Jun 01 '21 at 06:29

asked Jun 01 '21 at 06:26

Adithya Sama

What do you mean with "during creation"? Do you mean when you do `alter table ... add ...`? – Jun 01 '21 at 06:29
During "creation" I assume you mean when the table was created, ed `create table t (name text not null with default WHAT_IS_THIS)`? See dupe. – Bohemian Jun 01 '21 at 06:31
yes like @Bohemian said i mean the default value that was given to a column during creation. – Adithya Sama Jun 01 '21 at 10:03
on a separate note @a_horse_with_no_name, big fan. : ) – Adithya Sama Jun 01 '21 at 10:05

how to update a column with the default value set during creation in postgres?

0 Answers0