I have a need to display 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 of each column side-by-side. And just the 1st 10 rows would be sufficient 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?
i.e. 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