'How can I set a default value for a column in pgAdmin4?

I am working on a project with PostgreSQL as my database and using pgAdmin4 to interact with the data. I am trying to set a default value for a column but I can't seem to find an option for that. Can anyone help me with that?

sqlpostgresqlpgadmin


Solution 1:[1]

You can set a default value for column in pgadmin4,

  1. right click on table on your left side panel of database tree.
  2. click on properties.
  3. click on columns tab.
  4. In this pane on rightmost column you will have a default and you can populate it with values according to your datatype.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Nikhil B

Related Questions