I have the need to show the value stored in columns of separate tables where the tables and columns have nothing in common. I just want to compare the content of the rows in each column side by side. And only the first 10 rows would be enough for my purposes. There are no primary keys or common link between the tables.
I have many tables with hundreds of columns to compare. Is there a simple way to do this?
that is to say
Table1, column3 | Table2, column6 | Table3, column1
Resulting in something like the following
tbl1col3 | tbl2col6 | tbl3col1 123.9 | abc | x12 234.0 | bcd o23
Using postgresql 9.6, pgadmin4 v3.5