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