Quick Links

Changing from NOT NULL to NULL

From:	Rob Mosher <mosher(at)andrews(dot)edu>
To:	pgsql-novice(at)postgresql(dot)org
Subject:	Changing from NOT NULL to NULL
Date:	2004-02-15 19:57:35
Message-ID:	402FCF2F.3090807@andrews.edu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-novice

Is there anyway I can change a field to allowing nulls without dumping
the table, dropping it, recreating it as desired, and filling all the
data back in?

Thanks,
Rob Mosher

Responses

Re: Changing from NOT NULL to NULL at 2004-02-15 23:08:27 from Tom Lane
Re: Changing from NOT NULL to NULL at 2004-02-15 23:20:54 from Nabil Sayegh
Re: Changing from NOT NULL to NULL at 2004-02-15 23:33:20 from Michael Glaesemann

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Tom Lane	2004-02-15 23:08:27	Re: Changing from NOT NULL to NULL
Previous Message	Stephan Szabo	2004-02-15 19:56:38	Re: Send email when new record inserted