Postgres Pro
Downloads
Home   >   mailing lists

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

From Dan Browning
Subject Removing all NOT NULL constraints from multiple tables easily
Date
Msg-id 000401c01bf4$ba62ef30$1500000a@danb
Whole thread Raw
Responses Re: Removing all NOT NULL constraints from multiple tables easily
List pgsql-general
Tree view 
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-general by date:

Previous
From: Patrick Welche
Date:
Subject: Re: can't read SQL dump from MySQL
Next
From: "Andreas Jerke"
Date:
Subject: AW: can't read SQL dump from MySQL