| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
| Cc: | Neil Conway <neilc(at)samurai(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>, Jeff <threshar(at)torgo(dot)978(dot)org>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Fixed width rows faster? |
| Date: | 2004-03-07 03:01:22 |
| Message-ID: | 1078628481.57624.29.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-07 03:46:57 | Re: Feature request: smarter use of conditional indexes |
| Previous Message | Larry Rosenman | 2004-03-07 02:39:38 | Re: Feature request: smarter use of conditional indexes |