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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to