\gexec in PostgreSQL is handy when running a function that outputs dynamically generated SQL to be run to get final results
Tag: sql
Numeric column names in PostgreSQL
In the Udemy PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours course, there was a lesson where we wrote a function to output some SQL to enable dynamic pivot tables:pass the table_name, vertical_header_column, horizontal_header_column, value_column, and data_type and any table can be “pivoted”. Pretty nifty. But… it was hideously difficult to transcribe the code… Continue reading Numeric column names in PostgreSQL
PostgreSQL Pivot Tables
PostgreSQL Pivot Tables using \crosstabview with sortation based upon various criteria