Adding a new column

From: Gerard Samuel <gsam(at)trini0(dot)org>
To: pgsql-php(at)postgresql(dot)org
Subject: Adding a new column
Date: 2003-01-23 17:20:24
Message-ID: 3E302458.3000304@trini0.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

I have a table with data in it, and Im trying to add another column to it.
Im executing ->
ALTER TABLE search_content ADD COLUMN faq_id VARCHAR(33);
then
alter table search_content alter column faq_id set default '' not null;

Im getting an error ->
ERROR: parser: parse error at or near "null"

If I take out not null, the sql works but I need the column to be "not null"

What am I doing wrong???
Thanks

--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/

Browse pgsql-php by date

  From Date Subject
Next Message Josh Trutwin 2003-01-23 17:33:18 Re: PHP Abstraction Layer - Your Opinion Please
Previous Message Andrei Verovski (aka MacGuru) 2003-01-23 15:51:38 PHP Abstraction Layer - Your Opinion Please