PostgreSQL Notes

<p class="wp-block-paragraph">How to drop all tables sharing the same prefix in PostgreSQL?</p> <ul class="wp-block-list"> <li>Non-Cascade version:</li> </ul> <p class="wp-block-paragraph">How to drop all functions in PostgreSQL?</p> <p class="wp-block-paragraph"> How to drop all tables sharing the same prefix in PostgreSQL? Non-Cascade version: How to drop all functions in PostgreSQL?

Running PostgreSQL in Docker on my Mac

<p class="wp-block-paragraph">It’s extremely convenient to run your local tools, like RDMS, development environments and so on on Docker containers on Mac. To be honest with you, I hate installing a bunch of software on my Mac, and that’s the main reason why do I use containers for my local development.</p> <p class="wp-block-paragraph">Before doing that manual, … Read more