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