PostgreSQL supports the SQL join type: LATERAL. Useful for creating advanced query’s. What is a LATERAL join? In the PostgreSQL documentation: Subqueries appearing in FROM can be preceded by the key word LATERAL. This allows them to reference columns provided by preceding FROM items. (Without LATERAL, each subquery is evaluated […]
Read MorePost Tagged with: "PostgreSQL"
How to switch the active PostgreSQL cluster
A how to of switching the active PostgreSQL cluster version to make it bind to port 5432. Let’s define the active PostgreSQL cluster as the one that binds to port 5432 and having multiple versions running in Ubuntu. Check with pg_lscluster what is running: And what is the active PostgreSQL […]
Read More