Removing all NOT NULL constraints from multiple tables easily

From: "Dan Browning" <danb(at)cyclonecomputers(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Removing all NOT NULL constraints from multiple tables easily
Date: 2000-09-11 13:32:27
Message-ID: 000401c01bf4$ba62ef30$1500000a@danb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Jerke 2000-09-11 13:46:26 AW: can't read SQL dump from MySQL
Previous Message Patrick Welche 2000-09-11 13:22:56 Re: can't read SQL dump from MySQL

Browse pgsql-novice by date

  From Date Subject
Next Message syed asghar 2000-09-11 13:54:37 Copy
Previous Message DWalker 2000-09-11 12:56:38 Re: Multiple Selects