May 2018
Intermediate to advanced
576 pages
30h 25m
English
We'll start this recipe by creating two tables with a few test rows:
postgres=# CREATE TABLE ft(fk int PRIMARY KEY, fs text);CREATE TABLEpostgres=# CREATE TABLE pt(pk int, ps text);CREATE TABLEpostgres=# INSERT INTO ft(fk,fs) VALUES (1,'one'), (2,'two');INSERT 0 2postgres=# INSERT INTO pt(pk,ps) VALUES (1,'I'), (2,'II'), (3,'III');INSERT 0 3