Received: from mta3.snfc21.pbi.net (mta3.snfc21.pbi.net [206.13.28.141]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA64544 for ; Thu, 28 Oct 1999 02:36:23 -0400 (EDT) (envelope-from postgres@weblynk.com) Received: from pinto.usedcars.com ([206.170.239.155]) by mta3.snfc21.pbi.net (Sun Internet Mail Server sims.3.5.1999.09.16.21.57.p8) with SMTP id <0FKA006QMVO916@mta3.snfc21.pbi.net> for pgsql-sql@postgreSQL.org; Wed, 27 Oct 1999 23:36:10 -0700 (PDT) Date: Wed, 27 Oct 1999 23:34:16 -0700 From: Rich Ryan Subject: Setting default row value after select into table To: "pgsql-sql@postgresql.org" Message-id: <009a01bf210e$75b7c5e0$9befaace@usedcars.com> MIME-version: 1.0 X-Mailer: Microsoft Outlook Express 5.00.2314.1300 Content-type: text/plain; charset="iso-8859-1" Content-transfer-encoding: 7bit X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 References: <17667.940862730@sss.pgh.pa.us> <003001bf1f02$39e0e960$9befaace@usedcars.com> X-Priority: 3 When I do somthing like select cdate into table newt from oldt; and say, row cdate in table oldt had a default value of 'now', the new table newt doesn't have the default value anymore. This makes sense since it is copying just data, not meta-data into the new table. So, is there a way to alter the cdate row in the new table to have a default? Could not find an alter table command for this. Thanks, Rich