Postgres Pro
Downloads
Home   >   mailing lists

Re: Rich LIKE inheritance - Mailing list pgsql-general

From Richard Huxton
Subject Re: Rich LIKE inheritance
Date
Msg-id 47697C8F.3040500@archonet.com
Whole thread Raw
In response to Rich LIKE inheritance  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
Tree view 
Reg Me Please wrote:
> Hi all.
>
> Is there a way to inherit from a table with the LIKE construct and
> also get its indexes along with contraints, DEFAULTs and NOT NULLs?

CREATE TABLE ... LIKE isn't inheritance, it's copying the structure.

I believe you can duplicate indexes in 8.3.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: phpPgAdmin 4.2-Beta-1 translation status
Next
From: "Scott Marlowe"
Date:
Subject: Re: Deploy postgres - upgrade strategy