pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rod Taylor <pg@rbt.ca>
To: Mike Nolan <nolan@gw.tssi.com>
Cc: Neil Conway <neilc@samurai.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Bill Moran <wmoran@potentialtech.com>
Cc: Jeff <threshar@torgo.978.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Fixed width rows faster?
Date: Sat, 06 Mar 2004 22:01:22 -0500
Message-ID: <1078628481.57624.29.camel@jester> (raw)
In-Reply-To: <200403070226.i272QUE8006569@gw.tssi.com>
References: <200403070226.i272QUE8006569@gw.tssi.com>

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).




view thread (23+ messages)  latest in thread

Message-ID: <1078628481.57624.29.camel@jester>
Permalink:  ../1078628481.57624.29.camel@jester/
Also on:    postgresql.org/message-id/1078628481.57624.29.camel@jester

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pg@rbt.ca, nolan@gw.tssi.com, neilc@samurai.com, josh@agliodbs.com, wmoran@potentialtech.com, threshar@torgo.978.org
  Subject: Re: Fixed width rows faster?
  In-Reply-To: <1078628481.57624.29.camel@jester>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox