Re: [SQL] inheritance - Mailing list pgsql-sql

From Oliver Elphick
Subject Re: [SQL] inheritance
Date
Msg-id 199805291958.UAA05205@linda.lfix.co.uk
Whole thread Raw
In response to inheritance  (Bernhard Matthias Ertl <ertl@delos.dbs.informatik.uni-muenchen.de>)
List pgsql-sql
Bernhard Matthias Ertl wrote:
  >Hi,
  >
  >only two short questions:
  >+ does the postgresql 6.2.1 already support inheritance and
  >+ if I have the tables cities and capitals (like in the tutorial), how can
  >I add attributes of a city to a capital? Before the capital attributes,
  >after the capital attributes or do I have to insert a capital citiy into
  >the table city as well as into the table capital?
A descendant automatically inherits all attributes from its ancestor(s).

Try \d and see.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Let no man despise thy youth; but be thou an example
      of the believers, in word, in conversation, in
      charity, in spirit, in faith, in purity."
                                       I Timothy 4:12



pgsql-sql by date:

Previous
From: Bernhard Matthias Ertl
Date:
Subject: inheritance
Next
From: Bassel Hatoum
Date:
Subject: Trouble with dates