Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the breadcrumb-navxt domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/devtools/public_html/blog/wp-includes/functions.php on line 6131
{"id":476,"date":"2012-07-30T10:06:00","date_gmt":"2012-07-30T13:06:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/"},"modified":"2022-04-04T08:26:43","modified_gmt":"2022-04-04T11:26:43","slug":"concatenando-campos-no-postgresql","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/","title":{"rendered":"Concatenando campos no PostgreSQL"},"content":{"rendered":"
\n
<\/div>\n

Salve salve colegas.<\/p>\n

Dando seguimento a mat\u00e9ria de concatena\u00e7\u00e3o anterior, hoje trago at\u00e9 os colegas a forma de concatena\u00e7\u00e3o do PostgreSQL. Para quem j\u00e1 usa a vers\u00e3o 9 o comando concat est\u00e1 nativo<\/a>, por\u00e9m vers\u00f5es anteriores temos que utilizar o comando || (Dois pipe’s).<\/p>\n

Antes de aplicarmos a mat\u00e9ria com exemplos pr\u00e1ticos, gostaria de alertar quanto a concaten\u00e7\u00e3o de colunas que podem conter valores nulos, isto porque quando fazemos uma concatena\u00e7\u00e3o onde uma das colunas possui um valor Null, todo o resultado da concatena\u00e7\u00e3o tamb\u00e9m ser\u00e1 Null.<\/p>\n

Vamos ent\u00e3o a pr\u00e1tica:<\/p>\n

1 – Estrutura da tabela:<\/p>\n

 CREATE TABLE paposql.pessoa  \n (  \n  id bigint NOT NULL,  \n  nome character varying(20),  \n  sobrenome character varying(100),  \n  dt_nascimento date,  \n  CONSTRAINT pk_id_pessoa PRIMARY KEY (id )  \n<\/code><\/pre>\n
2 – Dados existentes:<\/p>\n
 Select nome , sobrenome, dt_nascimento  \n From paposql.pessoa  \n<\/code><\/pre>\n
 Papo;Sql;2012-01-01\n<\/code><\/pre>\n
<\/a>
\n3 – Concatenando os campos Nome e Sobrenome em um \u00fanico campo, separando-os por um espe\u00e7o:<\/p>\n
 Select nome || ' ' || sobrenome As Nome_Completo, dt_nascimento  \n From paposql.pessoa  \n<\/code><\/pre>\n
 Papo Sql;2012-01-01\n<\/code><\/pre>\n
Vejam que como esperado, os campos Nome e Sobrenome se concater\u00e3o gerando assim resultado em um \u00fanico campo (Nome_Completo).<\/p>\n
No exemplo utilizei um espa\u00e7o para separar as informa\u00e7\u00f5es, mas voc\u00ea pode adicionar o separador que desejar, haja visto que o tipo de dados do exemplo e uma string.<\/p>\n
Voc\u00ea tamb\u00e9m pode concatenar tipos de dados diferentes, vejamos um exemplo:<\/p>\n
 Select 'Nome da Pessoa :' || nome || ' ' || sobrenome || ' Data de Nascimento: ' || dt_nascimento   \n From paposql.pessoa  \n<\/code><\/pre>\n
 Nome da Pessoa: Papo Sql - Data de Nascimento: 2012-01-01\n<\/code><\/pre>\n
Neste caso adicione informa\u00e7\u00f5es para cadas campo, Nome da Pessoa e Data de Nascimento, para facilitar a visualiza\u00e7\u00e3o das informa\u00e7\u00f5es. Por\u00e9m, a data de nascimento apresentada possui um formato estrangeiro, onde podemos formata-la, para isto aconselho que veja este outro post<\/a>.<\/p>\n
Bom pessoal, espero que as dicas tenham sido mais uma vez \u00fateis e, sugest\u00f5es, cr\u00edticas ou elogios ser\u00e3o bem vindos.
\nGrande abra\u00e7o.<\/p>\n
Clique aqui e veja todas as mat\u00e9rias sobre PostgreSQL<\/span><\/i><\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Salve salve colegas. Dando seguimento a mat\u00e9ria de concatena\u00e7\u00e3o anterior, hoje trago at\u00e9 os colegas a forma de concatena\u00e7\u00e3o do PostgreSQL. Para quem j\u00e1 usa a vers\u00e3o 9 o comando concat est\u00e1 nativo, por\u00e9m vers\u00f5es anteriores temos que utilizar o comando || (Dois pipe’s). Antes de aplicarmos a mat\u00e9ria com exemplos pr\u00e1ticos, gostaria de alertar quanto a … Ler mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":793,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-476","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"yoast_head":"\nConcatenando campos no PostgreSQL<\/title>\n<meta name=\"description\" content=\"Aprenda como fazer a concatena\u00e7\u00e3o de campos no PostgreSQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Concatenando campos no PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"Aprenda como fazer a concatena\u00e7\u00e3o de campos no PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Devtools\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-30T13:06:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-04T11:26:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Fabiano Abreu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fabiano Abreu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\"},\"author\":{\"name\":\"Fabiano Abreu\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"headline\":\"Concatenando campos no PostgreSQL\",\"datePublished\":\"2012-07-30T13:06:00+00:00\",\"dateModified\":\"2022-04-04T11:26:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\"},\"wordCount\":277,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\",\"name\":\"Concatenando campos no PostgreSQL\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png\",\"datePublished\":\"2012-07-30T13:06:00+00:00\",\"dateModified\":\"2022-04-04T11:26:43+00:00\",\"description\":\"Aprenda como fazer a concatena\u00e7\u00e3o de campos no PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png\",\"width\":200,\"height\":200,\"caption\":\"postgresql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/devtools.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Concatenando campos no PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\",\"url\":\"https:\/\/devtools.com.br\/blog\/\",\"name\":\"Devtools\",\"description\":\"Sua caixa de ferramentas online\",\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devtools.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\",\"name\":\"Fabiano Abreu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"width\":184,\"height\":184,\"caption\":\"Fabiano Abreu\"},\"logo\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/devtools.com.br\/blog\"],\"url\":\"https:\/\/devtools.com.br\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Concatenando campos no PostgreSQL","description":"Aprenda como fazer a concatena\u00e7\u00e3o de campos no PostgreSQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/","og_locale":"pt_BR","og_type":"article","og_title":"Concatenando campos no PostgreSQL","og_description":"Aprenda como fazer a concatena\u00e7\u00e3o de campos no PostgreSQL","og_url":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/","og_site_name":"Devtools","article_published_time":"2012-07-30T13:06:00+00:00","article_modified_time":"2022-04-04T11:26:43+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png","type":"image\/png"}],"author":"Fabiano Abreu","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Fabiano Abreu","Est. tempo de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#article","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/"},"author":{"name":"Fabiano Abreu","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"headline":"Concatenando campos no PostgreSQL","datePublished":"2012-07-30T13:06:00+00:00","dateModified":"2022-04-04T11:26:43+00:00","mainEntityOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/"},"wordCount":277,"commentCount":0,"publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png","articleSection":["PostgreSQL"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/","url":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/","name":"Concatenando campos no PostgreSQL","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png","datePublished":"2012-07-30T13:06:00+00:00","dateModified":"2022-04-04T11:26:43+00:00","description":"Aprenda como fazer a concatena\u00e7\u00e3o de campos no PostgreSQL","breadcrumb":{"@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#primaryimage","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2011\/06\/postgresql-1.png","width":200,"height":200,"caption":"postgresql"},{"@type":"BreadcrumbList","@id":"https:\/\/devtools.com.br\/blog\/concatenando-campos-no-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/devtools.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Concatenando campos no PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/devtools.com.br\/blog\/#website","url":"https:\/\/devtools.com.br\/blog\/","name":"Devtools","description":"Sua caixa de ferramentas online","publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devtools.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed","name":"Fabiano Abreu","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","width":184,"height":184,"caption":"Fabiano Abreu"},"logo":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/devtools.com.br\/blog"],"url":"https:\/\/devtools.com.br\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/comments?post=476"}],"version-history":[{"count":1,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/476\/revisions"}],"predecessor-version":[{"id":617,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/476\/revisions\/617"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media\/793"}],"wp:attachment":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media?parent=476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/categories?post=476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/tags?post=476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}