Dynamic pivot query using PostgreSQL 9.3

by 
SELECT *
FROM   crosstab (
   'SELECT ProductNumber, ProductName, Salescountry, SalesQuantity
    FROM   product
    ORDER  BY 1'
, $$SELECT unnest('{US,UK,UAE1}'::varchar[])$$
  ) AS ct (
   "ProductNumber" varchar
 , "ProductName"   varchar
 , "US"   int
 , "UK"   int
 , "UAE1" int);

Detailed explanation:

Completely dynamic query for varying number of distinct Salescountry?

More Related Contents:

  1. PostgreSQL Crosstab Query
  2. Dynamic alternative to pivot with CASE and GROUP BY
  3. Pivot on Multiple Columns using Tablefunc
  4. How to convert primary key from integer to serial?
  5. Execute a dynamic crosstab query
  6. Is there a way to disable function overloading in Postgres
  7. Refresh a materialized view automatically using a rule or notify
  8. Why can I create a table with PRIMARY KEY on a nullable column?
  9. Dynamically generate columns for crosstab in PostgreSQL
  10. PostgreSQL 9.3: Dynamic pivot table
  11. Crosstab with a large or undefined number of categories
  12. How to reset postgres’ primary key sequence when it falls out of sync?
  13. The forgotten assignment operator “=” and the commonplace “:=”
  14. Passing user id to PostgreSQL triggers
  15. Do nullable columns occupy additional space in PostgreSQL?
  16. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  17. Disable PostgreSQL foreign key checks for migrations
  18. Prevent recursive trigger in PostgreSQL
  19. serial in postgres is being increased even though I added on conflict do nothing
  20. PostgreSQL Error: Relation already exists
  21. How to make a select with array contains value clause in psql
  22. Using row_to_json() with nested joins
  23. SQL Transpose Rows as Columns
  24. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  25. Update timestamp when row is updated in PostgreSQL
  26. How to add a conditional unique index on PostgreSQL
  27. Heroku database restore issue
  28. user postgres launches process that takes all CPUs 100% usage
  29. Postgres table column name restrictions?
  30. How do I get min, median and max from my query in postgresql?

Leave a Comment