Re: alter table

From: Maciej Piekielniak <piechcio(at)isb(dot)com(dot)pl>
To: "Owen Jacobson" <ojacobson(at)osl(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: alter table
Date: 2006-02-15 20:05:05
Message-ID: 1167961280.20060215210505@isb.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello Owen,

Wednesday, February 15, 2006, 8:56:05 PM, you wrote:
>> ALTER TABLE proc MODIFY name varchar(64) DEFAULT '' NOT NULL;

OJ> Not under 7.4.

Hmm, maybe postgres can copy constraints and properties in "create table .. as select"?

CREATE TABLE fv_wystawione
( abonament) AS SELECT a.nazwa from abonamenty a;

This command only copy data type.

--
Best regards,
Maciej mailto:piechcio(at)isb(dot)com(dot)pl

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2006-02-15 20:09:39 Re: alter table
Previous Message Stephan Szabo 2006-02-15 20:03:26 Re: alter table