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 fishing around in the pg_ system
tables.
-Owen
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
