Split comma separated column data into additional columns

by

split_part() does what you want in one step:

SELECT split_part(col, ',', 1) AS col1
     , split_part(col, ',', 2) AS col2
     , split_part(col, ',', 3) AS col3
     , split_part(col, ',', 4) AS col4
FROM   tbl;

Add as many lines as you have items in col (the possible maximum).
Columns exceeding data items will be empty strings ('').

More Related Contents:

  1. Split column into multiple rows in Postgres
  2. Split String by delimiter position using oracle SQL
  3. Select (retrieve) all records from multiple schemas using Postgres
  4. Fetch records that are non zero after the decimal point in PostgreSQL
  5. Select first row in each GROUP BY group?
  6. How do I escape a single quote in SQL Server?
  7. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  8. How to use RETURNING with ON CONFLICT in PostgreSQL?
  9. Does PostgreSQL support “accent insensitive” collations?
  10. PostgreSQL DISTINCT ON with different ORDER BY
  11. PostgreSQL: running count of rows for a query ‘by minute’
  12. Difference between language sql and language plpgsql in PostgreSQL functions
  13. Query with LEFT JOIN not returning rows for count of 0
  14. How to include “zero” / “0” results in COUNT aggregate?
  15. SQL SELECT speed int vs varchar
  16. delete “column does not exist”
  17. How to create a temporary function in PostgreSQL?
  18. Postgres Case Sensitivity
  19. Polymorphism in SQL database tables?
  20. Query for element of array in JSON column
  21. Casting NULL type when updating multiple rows
  22. How to round an average to 2 decimal places in PostgreSQL?
  23. Explain JOIN vs. LEFT JOIN and WHERE condition performance suggestion in more detail
  24. postgresql: INSERT INTO … (SELECT * …)
  25. INSERT COMMAND :: ERROR: column “value” does not exist
  26. Return multiple columns and rows from a function PostgreSQL instead of record
  27. Postgres error updating column data
  28. SQL LIKE condition to check for integer?
  29. Temporal database design, with a twist (live vs draft rows)
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment