| From: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
|---|---|
| To: | neilc(at)samurai(dot)com (Neil Conway) |
| Cc: | pg(at)rbt(dot)ca (Rod Taylor), josh(at)agliodbs(dot)com (Josh Berkus), wmoran(at)potentialtech(dot)com (Bill Moran), threshar(at)torgo(dot)978(dot)org (Jeff), pgsql-performance(at)postgresql(dot)org (Postgresql Performance) |
| Subject: | Re: Fixed width rows faster? |
| Date: | 2004-03-07 02:26:30 |
| Message-ID: | 200403070226.i272QUE8006569@gw.tssi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 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?
Something like COPY TABLE xxx TO TABLE yyy WITH CHECK CONSTRAINTS.
--
Mike Nolan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Siracusa | 2004-03-07 02:29:27 | Re: Feature request: smarter use of conditional indexes |
| Previous Message | Neil Conway | 2004-03-07 01:32:08 | Re: Fixed width rows faster? |