Re: alter table - Mailing list 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@isb.com.pl