Tutorial by Examples

CREATE TABLE users (username text, email text); CREATE TABLE simple_users () INHERITS (users); CREATE TABLE users_with_password (password text) INHERITS (users); Our three tables look like this: users ColumnTypeusernametextemailtext simple_users ColumnTypeusernametextemailtext users_with_p...

Let's create two simple tables: CREATE TABLE users (username text, email text); CREATE TABLE simple_users () INHERITS (users); Adding columns ALTER TABLE simple_users ADD COLUMN password text; simple_users ColumnTypeusernametextemailtextpasswordtext Adding the same column to the parent ta...