How can you display two tables side by side? Example:
> select * from t1; a | b ---+--- 2 | 2 3 | 5 4 | 7 9 | 0
> select * from t2; c | d ---+--- 4 | 5 7 | 3 3 | 2 1 | 1 2 | 0
Intended output: a | b | c | d ---+---+---+--- 2 | 2 | 4 | 5 3 | 5 | 7 | 3 4 | 7 | 3 | 2 9 | 0 | 1 | 1 | | 2 | 0
Each table has no keys (and no OIDs). Order is not important, but each row from each table needs to be displayed exactly once.
-- dave
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster