{"id":1846,"date":"2019-04-06T15:23:30","date_gmt":"2019-04-06T20:23:30","guid":{"rendered":"http:\/\/creativapixel.com\/?p=1846"},"modified":"2019-04-06T15:23:30","modified_gmt":"2019-04-06T20:23:30","slug":"dividir-contenido-de-una-columna-en-dos-o-mas-en-postgresql","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/dividir-contenido-de-una-columna-en-dos-o-mas-en-postgresql\/","title":{"rendered":"Dividir contenido de una columna en dos o mas en PostgreSQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hoy me encontr\u00e9 con una tabla persona con \nlos datos apellidos en un solo campo por lo que opte por buscar la forma\n mediante sql de obtener por separado cada apellido en una columna \ndistinta (apellido paterno, apellido materno).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Luego de unos minutos de realizar algunas b\u00fasquedas la soluci\u00f3n fue la siguiente:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT pers_apellidos,split_part(pers_apellidos,' ',1) AS apellido_paterno, split_part(pers_apellidos,' ',2) AS apellido_materno FROM persona<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">La soluci\u00f3n fue utilizar una funci\u00f3n que separa cadenas seg\u00fan un delimitador:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">split_part()<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SINTAXIS<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>split_part(string,delimiter,field)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">string: la cadena que queremos separar\ndelimiter: el delimitador\nfield: la posici\u00f3n de texto que queremos mantener<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">quedando:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"295\" src=\"http:\/\/creativapixel.com\/wp-content\/uploads\/2019\/04\/split-posgresql_m.png\" alt=\"\" class=\"wp-image-1847\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2019\/04\/split-posgresql_m.png 448w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2019\/04\/split-posgresql_m-300x198.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">listo!!! ahora su respectivo UPDATE.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy me encontr\u00e9 con una tabla persona con los datos apellidos en un solo campo por lo que opte por buscar la forma mediante sql de obtener por separado cada &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1847,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-1846","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/comments?post=1846"}],"version-history":[{"count":1,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1846\/revisions"}],"predecessor-version":[{"id":1848,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1846\/revisions\/1848"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/1847"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=1846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=1846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=1846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}