Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

Next:From: syed asgharDate: 2000-09-11 13:54:37
Subject: Copy
Previous:From: DWalkerDate: 2000-09-11 12:56:38
Subject: Re: Multiple Selects

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group