Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision Next revisionBoth sides next revision | ||
kb:pg:nasledjivanje_tabela [2019/11/14 12:30] – created nessa | kb:pg:nasledjivanje_tabela [2019/11/14 12:35] – nessa | ||
---|---|---|---|
Line 2: | Line 2: | ||
PostgreSQL ima mehanizam za nasleđivanje između tabela ([[https:// | PostgreSQL ima mehanizam za nasleđivanje između tabela ([[https:// | ||
+ | |||
+ | Primer:< | ||
+ | CREATE TABLE cities ( | ||
+ | name text, | ||
+ | population | ||
+ | altitude | ||
+ | ); | ||
+ | |||
+ | CREATE TABLE capitals ( | ||
+ | state | ||
+ | ) INHERITS (cities); | ||
+ | </ | ||