Dynamic Pivot Table Generation with Variable Columns

Design a flexible stored procedure that can dynamically generate pivot tables based on runtime parameters. The procedure should accept a table name, pivot column, aggregation column, and aggregation method as inputs. Implement error handling to manage scenarios where specified columns don't exist, and include performance optimization techniques for large datasets. Provide a comprehensive solution that works across different PostgreSQL versions and handles complex data type conversions.