Re: Removing all NOT NULL constraints from multiple tables easily

Yes, but you'll probably not like it... You can modify the
system tables to remove the not nulls. We don't yet have
the ALTER TABLE syntax for doing it...
You're usually better off dumping and reimporting, but I
believe the query below should do it if you really want to
try (make a safety dump first though)...

update pg_attribute set attnotnull='f' where
exists (select * from pg_class where pg_class.oid=attrelid
and pg_class.relname!~'^pg_') and attnotnull='t';

Stephan Szabo
sszabo(at)bigpanda(dot)com

On Mon, 11 Sep 2000, Dan Browning wrote:

> 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
>