-- Example: Orders have a default total of 0 cents alter table orders alter column total_cents set default 0; -- Example: Items are available by default alter table items alter column available set default true; links: https://www.postgresql.org/docs/9.5/ddl-alter.html https://www.postgresql.org/message-id/4558AA88.3070102@brainscraps.com
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter