CREATE TABLE AS ...

From: Raphael Bauduin <raphael(dot)bauduin(at)be(dot)easynet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: CREATE TABLE AS ...
Date: 2002-07-23 13:45:12
Message-ID: 20020723134512.GA22069@raphael
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Raphael Bauduin 2002-07-23 13:48:07 CREATE TABLE AS ...
Previous Message Tom, Leung S. 2002-07-22 19:44:13 NIS+ password