pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Neil Conway <neilc@samurai.com>
To: Mike Nolan <nolan@gw.tssi.com>
Cc: Rod Taylor <pg@rbt.ca>
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 20:32:08 -0500
Message-ID: <404A7B98.7090401@samurai.com> (raw)
In-Reply-To: <200403070116.i271GWPS005869@gw.tssi.com>
References: <200403070116.i271GWPS005869@gw.tssi.com>

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.

-Neil



view thread (23+ messages)  latest in thread

Message-ID: <404A7B98.7090401@samurai.com>
Permalink:  ../404A7B98.7090401@samurai.com/
Also on:    postgresql.org/message-id/404A7B98.7090401@samurai.com

 · 

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: neilc@samurai.com, nolan@gw.tssi.com, pg@rbt.ca, josh@agliodbs.com, wmoran@potentialtech.com, threshar@torgo.978.org
  Subject: Re: Fixed width rows faster?
  In-Reply-To: <404A7B98.7090401@samurai.com>

* 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