Postgres Pro
Downloads
Home   >   mailing lists

Thread: Changing a column constraint?

Changing a column constraint?

From
Henry Holland
Date:
Hi,

If I have a column constraint:addr_type char( 10 ) default 'street'CHECK( addr_type = 'street' || addr_type = 'pobox'
),
in a table, how can I add another choice to the list after I've already
entered data into the table?

Henry