--On mardi 23 juillet 2002 15:48 +0200 Raphael Bauduin
<raphael@be.easynet.net> wrote:
> Hi,
>
> In a data model change, I wanted to use the "create table as select"
> feature. However, I want that table to have a primary key defined, and
> thus a field defined as NOT NULL. I didn't find a way to add a NOT NULL
> constraint on a column of an existing table. If there isn't, what's the
> best way to go? A COPY?
why not just :
create table new_table (new fields with all you need);
insert into new_table <the same select as you had in your create as>;
--
Mathieu Arnold