Re: [GENERAL] Inherits tables and current CVS

Teodor Sigaev <[EMAIL PROTECTED]> writes: > How can I know tables is inherited or no? You have to look in pg_inherits. AFAIR psql has no \d command that will tell you anything about it. regards, tom lane ---(end of broadcast)--

[GENERAL] Inherits tables and current CVS

How can I know tables is inherited or no? # create table parent ( id int primary key, value text ); # create table child ( cvaltext, primary key (id) ) INHERITS (parent); # \d child Table "public.child" Column | Type | Modifiers +