CREATE TABLE AS ...

From: Raphael Bauduin <raphael(at)be(dot)easynet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: CREATE TABLE AS ...
Date: 2002-07-23 13:48:07
Message-ID: 20020723134807.GB22069@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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Artur Pietruk 2002-07-23 14:40:32 Re: CREATE TABLE AS ...
Previous Message Raphael Bauduin 2002-07-23 13:45:12 CREATE TABLE AS ...