X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D9788D1D165 for ; Sun, 7 Mar 2004 03:00:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76259-04 for ; Sat, 6 Mar 2004 23:00:44 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5806DD1C96F for ; Sat, 6 Mar 2004 23:00:40 -0400 (AST) Received: from [134.22.71.174] (dyn-71-174.tor.dsl.tht.net [134.22.71.174]) by tht.net (Postfix) with ESMTP id 757CF76A1A; Sat, 6 Mar 2004 22:00:48 -0500 (EST) Subject: Re: Fixed width rows faster? From: Rod Taylor To: Mike Nolan Cc: Neil Conway , Josh Berkus , Bill Moran , Jeff , Postgresql Performance In-Reply-To: <200403070226.i272QUE8006569@gw.tssi.com> References: <200403070226.i272QUE8006569@gw.tssi.com> Content-Type: text/plain Message-Id: <1078628481.57624.29.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sat, 06 Mar 2004 22:01:22 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/84 X-Sequence-Number: 5940 On Sat, 2004-03-06 at 21:26, Mike Nolan wrote: > > Mike Nolan wrote: > > > Is there a way to copy a table INCLUDING the check constraints? If not, > > > then that information is lost, unlike varchar(n). > > > > "pg_dump -t" should work fine, unless I'm misunderstanding you. > > I was specifically referring to doing it in SQL. > > The COPY command goes from table to file or file to table, the > CREATE TABLE ... SELECT loses the check constraints. > > Is there no SQL command that allows me to clone a table, including check > constraints? There is not in the spec or in PostgreSQL. Although, this may be a relevant extension to the LIKE structure inheritance in 200N spec (partly implemented 7.4).