Re: alter table

Maciej Piekielniak wrote:
>
> 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"?

What is it you're actually trying to accomplish?  There's got to be a better way, but without understanding what you're
doing(rather than how) it's hard to give you advice. 

CREATE TABLE AS and SELECT INTO only reproduce data, not metadata.  AFAIK duplicating a table's constraints involves
fishingaround in the pg_ system tables. 

-Owen