Search code examples
postgresqlpgadminpgadmin-4

ALTER Table in PGAdmin4

I can't seem to find where I can ALTER TABLE from within Pgadmin4; I don't see any options to. I would like to edit the default values for some tables/columns as 0 instead of NULL. Thanks!

Solution

  • You can right click on the table of interest, then select properties

    On the columns tab, you can add a new one or edit an existing column.

    By clicking on the edit icon on its left, you gain access to finer controls. Go to the constraint tab and there you can set the default value.

    enter image description here