Removing all NOT NULL constraints from multiple tables easily - Mailing list pgsql-novice

From Dan Browning
Subject Removing all NOT NULL constraints from multiple tables easily
Date
Msg-id 000401c01bf4$ba62ef30$1500000a@danb
Whole thread Raw
List pgsql-novice
I would like to remove all NOT NULL constraints from my tables.

I've tried ALTER TABLE, but I can't seem to get the syntax right, and the
docs aren't clear to me.
What is the correct syntax?  If there's another way, short of manually
recreating (dump, create, import) the tables, I'd love to hear it.

Thanks,

Dan Browning
Network & Database Administrator
Cyclone Computer Systems


pgsql-novice by date:

Previous
From: DWalker@black-oak.com
Date:
Subject: Re: Multiple Selects
Next
From: syed asghar
Date:
Subject: Copy