CREATE TABLE AS ... - Mailing list pgsql-admin

From Raphael Bauduin
Subject CREATE TABLE AS ...
Date
Msg-id 20020723134807.GB22069@raphael
Whole thread Raw
Responses Re: CREATE TABLE AS ...  (Artur Pietruk <arturp@plukwa.pdi.net>)
Re: CREATE TABLE AS ...  (Bruno Wolff III <bruno@wolff.to>)
Re: CREATE TABLE AS ...  (Mathieu Arnold <mat@mat.cc>)
List pgsql-admin
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?

Thanks.

Raph


pgsql-admin by date:

Previous
From: "Tom, Leung S."
Date:
Subject: NIS+ password
Next
From: Artur Pietruk
Date:
Subject: Re: CREATE TABLE AS ...