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