Sep 26, 2024 • 4 min read List Your psql Scripts Organize and quickly access your PostgreSQL scripts from within psql using aliases and clever shell tricks. #postgresql #bash #database #scripts #productivity
Aug 30, 2024 • 2 min read PostgreSQL: Count Rows in All Tables in Schema Use a CTE and psql's \gexec to efficiently count rows across all tables in your PostgreSQL schema. #postgresql #database #sql