Breaking News: Grepper is joining You.com. Read the official announcement!

split string as postgres

DreamCoder answered on March 22, 2023 Popularity 9/10 Helpfulness 4/10

answer split string as postgres

split string as postgres

Comment

SELECT
  val_arr[1] AS genus,
  val_arr[2] AS species
FROM (
  SELECT string_to_array(val, ' ') as val_arr
  FROM (
    VALUES
      ('aaa bbb'),
      ('cc dddd'),
      ('e fffff')
  ) t (val)
) tt;

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: string whatever

Link to this answer
Share Copy Link

Contributed on Mar 22 2023

DreamCoder

0 Answers Avg Quality 2/10

Closely Related Answers

split string as postgres

Comment

WITH yourTable AS (
    SELECT 'Mallotus philippensis'::text AS genus
)

SELECT
    SPLIT_PART(genus, ' ', 1) AS genus,
    SPLIT_PART(genus, ' ', 2) AS species
FROM yourTable;

https://www.postgresql.org/docs/9.1/functions-string.html, https://www.postgresqltutorial.com/postgresql-string-functions/postgresql-split_part/

Popularity 9/10 Helpfulness 7/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 22 2023

DreamCoder

0 Answers Avg Quality 2/10