Received: from venkat.vxl.co.in ([202.54.39.170]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA05753 for ; Fri, 29 Oct 1999 09:32:55 -0400 (EDT) (envelope-from imtiaz_sm@yahoo.com) Received: from yahoo.com (root@localhost [127.0.0.1]) by venkat.vxl.co.in (8.8.7/8.8.7) with ESMTP id TAA13500 for ; Fri, 29 Oct 1999 19:06:29 +0530 Sender: root@venkat.vxl.co.in Message-ID: <3819A2DC.7EE6C077@yahoo.com> Date: Fri, 29 Oct 1999 19:06:28 +0530 From: "Imtiaz. S. M" Organization: VXL Instruments Ltd. X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re :Setting default row value after select into table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Try this create table newtable as select set_of_columns from oldtable Rich Ryan wrote 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