Re: not null

Hi Ryanne,

As already suggested, a SERIAL is just an column that has a default of
the nextval() of an implicitly defined SEQUENCE.

So, try:

ALTER TABLE table_name ALTER COLUMN column_name SET DEFAULT
nextval('column_name_seq'::text);
CREATE SEQUENCE column_name_seq;

Cheers

Matthew.

On Saturday, January 25, 2003, at 10:52  PM, ryanne cruz wrote:

>
> hi list.
>
> i have a column that has a "not null" as its modifier. is there a way
> that i
> can remove that? or better yet to make it a "serial not null"?


--
Matthew Horoschun
Network Administrator
CanPrint Communications Pty. Ltd.


--
Matthew Horoschun
Network Administrator
CanPrint Communications Pty. Ltd.

Mobile:        0417 282 378
Direct:        (02) 6295 4544
Telephone:    (02) 6295 4422
Facsimile:     (02) 6295 4473