removing "not null" modifier

From: Robert Urban <urban(at)UNIX-Beratung(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: removing "not null" modifier
Date: 2006-03-13 13:07:03
Message-ID: 200603131307.k2DD73BB020477@noisy.spielwiese.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

let's say I have created a postgresql-7.2.2 db using the following cmds:

CREATE TABLE status
(
id SERIAL NOT NULL PRIMARY KEY,
name VARCHAR(32)
);

CREATE TABLE event
(
id SERIAL NOT NULL PRIMARY KEY,
description VARCHAR(32),
status_id INTEGER NOT NULL REFERENCES status(id)
);

in psql I then see:

mydb=# \d event
Table "event"
Column | Type | Modifiers
-------------+-----------------------+--------------------------------------------------
id | integer | not null default nextval('"event_id_seq"'::text)
description | character varying(32) |
status_id | integer | not null
Primary key: event_pkey
Triggers: RI_ConstraintTrigger_43210

The question:

how can I get rid of the "not null" modifier on status_id?

thanks,

Robert Urban

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Caune 2006-03-13 14:21:41 Re: Ask a PostgreSql question (about select )
Previous Message Markus Schaber 2006-03-13 12:34:23 Re: Set generating functions and subqueries